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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-07-25 : 01:51:13
|
| I have 5 server.in A server i designed one package, samething i need to move on to B server. How to import this dts package in to B server. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-25 : 06:01:43
|
| You can find many tips in the web to do this by programs, but maybe it doesn't work and you spend a lot of time to make it working.The light way is:Open your package.Save it as structured file (dont know the english version in german it's named "strukturierte Speicherdatei".)Connect Enterprise Manager to dest. Server.Right click on Folder Data Transformation ServicesChoose open package and navigate to your saved fileNow you can edit your package to change Server and anything other...In Package menu choose save asIn the Savedialog choose SQL Server instead of filedoneWebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
 |
|
|
|
|
|
Move DTS one server to another server