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.
