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 |
|
tocroi72
Yak Posting Veteran
89 Posts |
 Posted - 2005-06-09 : 10:55:42
|
| Hi All,I have a DTS package i need to tranfer to a different server. I have to do the "save as" then go the destination server to change the property (connection...to point to the destination server instead of the original one)Is there a quick way to transfer DTS packages between 2 servers without going to the destination server and change connection property?Thanks |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-06-09 : 11:02:54
|
| you have to change the connection propertyI find it best to use the combination a an ini file and a set of dynamic properties.I often do this and its not that tedious. you only have to set the ini file up once for each server and then when you do your transfer (save as) it will just work!If you want to save a bunch of dts packages to disk, use this - it's the best free tool for the job I've seen yet.It also does server transfer:http://www.sqldts.com/default.aspx?t=6&s=105&i=242&p=1&a=0 |
 |
|
|
tocroi72
Yak Posting Veteran
89 Posts |
Posted - 2005-06-09 : 11:20:55
|
| Could you be more detail on setting up the INI file if you don't mind.Thanks |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-06-09 : 11:49:43
|
| it's just a text file but you change the file extension from .txt to .iniand then you put something like this in it[MyDataBase]Server=(local)Username=saPword=MypasswordDatabase=mydb[MyDataBase2]Server=OtherServerNameUsername=saPword=mypassword2Database=mydb2I'm afraid you may have a steep learning curve ahead of you |
|
|
|
tocroi72
Yak Posting Veteran
89 Posts |
Posted - 2005-06-09 : 12:52:26
|
| i see, thanks ! i'll try. |
|
|
|
|
|
|
Transferring DTS packages