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 |
|
TimChenAllen
Starting Member
45 Posts |
 Posted - 2003-11-25 : 05:19:49
|
| I have two DTS questions. I'm on SQL 2000:1) I have saved a DTS quite a few times, and it has many versions. I'd like to save only the last version of the DTS, or delete the old version individually. How can I do that?2) My DTS has several OLEDB SQL Server connections that I have made by creating one good one, then making copies. The copy name ends up being "SRVFOO Copy", "SRVFOO Copy 2"..., which I then rename correctly. When I do a "Disconnected Edit", I see those old connections (like "SRVFOO Copy") hanging around. Any way of getting rid of those?Thanks in advance.--TimothyAllen[url]http://www.timallen.org[/url] |
|
|
TimChenAllen
Starting Member
45 Posts |
Posted - 2003-12-03 : 04:53:37
|
| A friend of mine gave me the answer to this (thanks Andrew).Get rid of old Versions: Right click on the DTS package and select "Versions...". You can delete a version permanently from the resulting window.Get rid of old Connections: There is no good way to do this. The only way he knew of was to create a new connection with the same name as the old connection and delete its icon.--TimothyAllen[url]http://www.timallen.org[/url] |
 |
|
|
TimChenAllen
Starting Member
45 Posts |
Posted - 2003-12-10 : 13:03:59
|
| I found how to clean old connections as well. It's rather labor-intensive. Anyway, in the DTS, create a new connection, and instead of writing a new name, click "Existing Connection" and select the name of the connection you want to erase (usually these are like "Blah blah Copy". Click OK and then delete the resulting connection.Obviously this is the kind of thing better done at the moment you create an unwanted connection. I had to do this on 12 DTS with about 50 unwanted connections each. My eyes hurt now.--Timothy Chen Allenemail me if you have a job in New Orleans for me[url]http://www.timallen.org[/url] |
|
|
|
|
|
|
Save only last version/Clean old connections?