Disable DTS package task and reschedule DTS job.

Problem

How you can disable task from DTS package and reschedule job.

Solution

Why reschedule job required after DTD package change?

When DTS package change system automatically generates new GUID, hence rescheduling of job required.

My DTS package name PropertyDM

Steps

     1.  Login to server and open Enterprise Manager (SQL server 2000)

     2.  Open Data Transformation Service.

     3. Click Local Packages.

     4. Right Click PropertyDM DTS Package and click Design Package.

    5. Right Click step (to Disable) workflow properties

     6.  New Window appeared, now go to options tab--> check the disable this step     

        checkbox...

        Click OK.

     7. Save the changes

     

     8. Open Management-->Sql Server Agent-->Jobs 

     9.  Right Click PropertyDM job --> Select Delete 

    

   

 10. Click Local Packages 

   

 11.Right Click PropertyDM DTS Package and click Schedule Package. 

   12.  New window appeared.  

   

  13. Change Occurs once at:  12:29 AM(Schedule Time) click OK button.

I hope this helps you to disable DTS package task.