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 |
|
dyckwal
Yak Posting Veteran
58 Posts |
 Posted - 2003-12-18 : 05:54:13
|
| Hello,I have my development database ready, including the DTS packs.Now I need to transfer everything to the real server. The database is simpel, I do a detach, copy the files onto a CD-ROM, and do a attach again after copying the database.But what with the DTS Packs....I know I can do 'save as' but the new server is sitting somewhere in france...Any tips or hints??Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-12-18 : 06:43:50
|
| It's easier if you run the dts packages from storage files then you just copy the files.You could save all your packages as files put the files on cd then load and save them to msdb on the destination.The packages are all in msdb..sysdtspackages so you could dump that table and load it on the destination using bcp.==========================================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. |
 |
|
|
dyckwal
Yak Posting Veteran
58 Posts |
Posted - 2003-12-18 : 10:06:55
|
| I've saved one as a file (extention .dts) but how do I reload them at the target server?Through the dts editor or ?? |
|
|
|
JaredStokes
Starting Member
9 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-18 : 12:25:01
|
| To load your DTS package from a file, right click on data transformation packages in EM and go to Open Package...Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-12-18 : 12:41:17
|
| See dtsrun - it has an option to load from a storage file rather than msdb.==========================================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. |
|
|
|
dyckwal
Yak Posting Veteran
58 Posts |
Posted - 2003-12-18 : 12:56:55
|
| I'm sorry tduggan, but EM means.... |
|
|
|
Granick
Starting Member
46 Posts |
Posted - 2003-12-18 : 13:06:36
|
| Enterprise Manager |
|
|
|
dyckwal
Yak Posting Veteran
58 Posts |
Posted - 2003-12-19 : 06:30:07
|
| Thanks, that works, and its very simpel..just need to copy some files then. |
|
|
|
|
|
|
Moving DTS packs...