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 |
|
ultraman
Starting Member
18 Posts |
 Posted - 2004-10-26 : 10:22:10
|
| Hi !I red many topics on the DTS exportation already, but I can't make any of them works.I tried saving as structured file, then I don't know how to load them in the Destination server ???I tried copying msdb..sysdtspackages from the source server to the destination. Then again, I don't see the new packages in the 'Local Packages' tab of the Enterprise Manager GUI.How do I get to see my imported packages once they're imported ???--------------Ultraman |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-26 : 12:40:36
|
| Did you do a refresh after the copy?To load the structured storage file copy to destination server, right click Data transformation services, open package, ...Then you can save it to the server.I would advise leaving all packages as structured storage files and loading them from files.==========================================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. |
 |
|
|
ultraman
Starting Member
18 Posts |
Posted - 2004-10-26 : 14:08:09
|
| I finaly ended up using a little VB6 app that I found on http://www.sqldts.com/redir.aspx?1209I rewrote it in C#, add manual input to specify the source and destination servers infos. Et Voilà ! Thanks to this, my life is a lot easier now.--------------Ultraman |
|
|
|
|
|
|
DTS exportation