-
Accessing MS Access DB on web server using DTS
Hi,
I have a prblm hope you guys provide me the right solution at the earliest. The scenario is described below.
I am trying to execute a DTS package where in data from access is read and written to sql server, I have designed the package but while establishing the connection to access db, DTS expects the physical path of the database, but in reality on production server, database is stored in webserver, my question is how to set the DTS to access the access db placed on a web server, can I make use of a DSN? or ftp to down load database to some physical location and read data from there?
Regards,
Sanrek
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|