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 |
|
sequeldba1
Starting Member
1 Post |
 Posted - 2007-06-05 : 11:22:35
|
| I am new to DTS packages. Please help in solving the below problemI have 4-5 DTS packages with more than 100 connections. If I want to change the connections of the source (Oracle Database) from Server 1 to Server 2, how do I do it dynamically....? I know that I can go to Disconnected Edit and change the connections manually , but it is a very tedious process as there are more than 100 connections. Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-05 : 23:13:08
|
| I don't know any easier way. |
 |
|
|
|
|
|
Changing Connections in DTS Package