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 |
|
Mike Coffey
Starting Member
2 Posts |
 Posted - 2002-10-15 : 11:20:47
|
| I created some packages to be used with one of my firm's clients that now need to be rolled out to some other clients.Issue: I used the client's name in some of the connection names, and now need to rename it to something generic. When I select the connection icon and point it to a new connection, the old connection's name still remains as an option to select when steps are added or modified.I really would like to avoid a week of re-doing these packages. Is there a way to remove unused connections out of a package? |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-10-16 : 08:43:58
|
| If you create a new connection and then direct all of your tasks to this new connection, then remove your old connection you should be okay. You also have the option to save your DTS job as a BAS file which will give you a lot more control over the DTS job.JamesH. |
 |
|
|
|
|
|
Connections within a package