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 |
|
oitsubob
Yak Posting Veteran
70 Posts |
 Posted - 2008-03-06 : 13:28:20
|
| Hi All!I'm attempting to migrate scheduled jobs for our DTS packages from one server to another. I've transfered them over using the Transfer Jobs Task in the DTS designer.We've also migrated all the DTS packages over and made the necessary changes to the file and database connections.The problem we're encountering, depite the changes we've made, is that when the jobs execute on the new server, they seem to be executing the DTS packages on the old server, which is still in place.I've tried scripting out the jobs to see if there were any references to the old server and I'm not finding anything. The only place I can think it might be is in the DTSRUN command with the long encrypted string of characters that may somehow reference the old server.Any thoughts, ideas or suggestions on how to fix this? I've got 100 or so packages and would rather not have to reschedule them all again - ugh!Thanks,Bob |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-06 : 13:35:20
|
| You used the DTS scheduler wizard to create the jobs as evidenced by the encrypted characters. Yes it has the old parameters. You need to manually reschedule all of them on the new server. I'd highly suggest doing it without the wizard that way you can type in the parameters and they won't be encrypted. You can then easily move jobs to other servers and change parameters.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
oitsubob
Yak Posting Veteran
70 Posts |
Posted - 2008-03-06 : 13:56:01
|
| Thanks Tara! I was afraid of that. Lesson learned :)Take Care,Bob |
|
|
|
|
|
|
Transfer SQL2000 Jobs to a new SQL2000 Server