You can run a query using the xp_cmdshell extended procedure to execute DOS commands.  You can type in your command statemetns and run in a DTS package.

Good Luck,

Mike

Not a DTS solution, but why don't you use the Get Data feature from Excel.  It can then refresh the data each time it is opened.  If you don't want...

You can not map a web folder as a drive without 3rd party software.  As I am not an administrator on the server where the package exists, or where the...