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