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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-03-17 : 17:48:18
|
| Hi,I moved some dts packages and jobs from sql server 2000 (default) to sql server 2005 (named). To move dts packages I created linked server to 2000 and used select * from linkedserver.msdb.dbo.sysdtspackages. Now dts packages are in 2005 under legacy folder. Then I moved jobs through trnasfer job option in ssis. These dts packages have connection string which point to previous instance of sql server 20000. I cannot modify these dts packages. please let me know how to do it. Secondly ssis is alreay installed on new 2005 instance. I used dts migration wizard. now packages are in ssis. how to deply them so they create an entry in msdb and create respective jobs.Thanks |
|
|
|
|
|
DTS Packages