I have a number of DTS packages that I have scheduled and so I have a list of Jobs. Within each Job there is a step that contains the DTSRun command to run the DTS package. My problem is that the DTSRun command is encrypted (/~Z etc...) and I want to move the jobs and DTS packages from SQL Server 7 to SQL Server 2000. I can easily move both the Jobs and Packages but the encrypted command still points to the old server and I don't know how to regain the relationship between DTS Package and Job. Any help greatly appreciated as i wasn't bald two days ago!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Moving Jobs and DTS to another server!
- Thread starter ukflix
- Start date
nigelrivett
IS-IT--Management
You can change the dts run command to use the package name instead - see dtsrun in bol.
I always call an SP to run dts packages which logs the call and completion and sets any glabal parameters.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
I always call an SP to run dts packages which logs the call and completion and sets any glabal parameters.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question