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)
 Deleted DTS task still runs

Author  Topic 

net4hire
Starting Member

6 Posts

Posted - 2004-10-14 : 13:04:27
I modified an existing DTS package by deleting an active x scripting task that creates a file. When I now run the package, the file is still created even though the task is already deleted.

I appreciate any help...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-14 : 13:43:38
SQL Server stores multiple version of the DTS Package. If you scheduled the package via the wizard, then the job is referencing a specific version. So to fix this, either don't use the wizard to setup jobs (use dtsrun.exe in a job) or delete the job and reschedule it via the wizard.

Tara
Go to Top of Page
   

- Advertisement -