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.
| Author |
Topic |
|
shashiondwh
Starting Member
4 Posts |
 Posted - 2010-04-23 : 05:51:59
|
| Hi team ,I have 5 dts packages on Prod server which are all scheduled in another DTS package using the Execute Package Tasks ( this package is scheduled to run every day at 9am) . There are 5 Execute Package Tasks for 5 packages. Now I have made changes to two packages and deployed to the same Prod server . In the process of deploying, I have deleted the existing before uploading the modified packages .My question is,post deployment, do I need to do any changes to the scheduler dts packages which holds all Execute Package Tasks to retain the existing scheduling of packages execution .I am not changing the package names .I am using SQL server 2000 .Please help me .thanks in Advance .shashi |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-23 : 06:02:47
|
Have a look at the job steps.Is the command like this?DTSRun /~Z0xD0C8471CEBFA8208D...Then I think you have to make it new.Is the command like this?dtsrun /Sservername /Uusername /Ppassword /N"Packagename"Then it should be ok.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
DTS pacakge schduling