Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS not run when remote calling

Author  Topic  csleaw Starting Member 1 Post Posted - 2006-03-22 : 19:26:53 I'm facing a problem on running DTS(for exporting data) where web server and database server located in different location. I used SQL 2000 and store procedure(OLE method to create DTS package) to call DTS by passing in global variable for data export location (web server). Previously , i'm not facing any problem where the db and web server in a same server. After seperate to 2 different location, i share the web server folder and mapped drive in database server, it does not work at all. I try to change the mapped drive letter in DTS package to UNC path also does not help. Please help. Thank you.