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 |
|
cheechwan
Starting Member
11 Posts |
 Posted - 2006-08-03 : 05:38:46
|
| Hi Experts,I have created few sets of my DTS Package in my SQL Server, however, i would like to migrate these DTS package to a new server.Does anyone know how to migrate all these set of DTS Package? or any ideas how to save these DTS package out and load into a new server?ThanksSteven Leong |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-03 : 11:00:58
|
| Save the dts packages as structured storage files.Copy the files to the other server.You can import them but it's better to just run the files.You can also copy the rows from msdb..sysdtspackages which is where the packages are held when saved to sql server==========================================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. |
 |
|
|
|
|
|
Save or Export DTS Packaged