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)
 Scheduled DTS Error

Author  Topic 

timsweet
Starting Member

31 Posts

Posted - 2005-09-02 : 11:59:15
Greetings,

I have DTS package that will run when manually executed with no errors.

If I schedule it errors because it can't find the destination file (path).

Did I miss something in the scheduling?

Thanks in advance

mmarovic
Aged Yak Warrior

518 Posts

Posted - 2005-09-02 : 13:43:39
When you run it from EM on your computer, you are exporting data to a local file. When you run it on the server specified path doesn't exist there.
Go to Top of Page
   

- Advertisement -