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 |
|
SQLboom
Yak Posting Veteran
63 Posts |
 Posted - 2004-02-17 : 00:19:05
|
| Two very simple queries about DTS. .. 1. How do we avoid DTS saving earlier versions?2. How do we Delete/Rename a connection in DTS Package?Thanks. |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2004-02-17 : 06:08:50
|
| There's no option to prevent DTS from saving previous versions. However you can delete unwanted versions from within Enterprise Manager, by right clicking on the package and selecting Versions from the popup menu. Versions are stored in msdb..sysdtspackages. You might want to look into this undocumented procedure in msdb called sp_drop_dtspackage.Regarding your second question, see if this helps: http://www.sqldts.com/default.aspx?253--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-17 : 06:25:21
|
| I save dts packages to structured storage files and delete the copy on disk before saving the changed versio and hold everything in sourcesafe.It seems odd to hold dts packages in a database.To delete a connection just roght click in enterprise manager and delete the connection icon.If you have old ones without the icon just create a new connection with that name then delete it.To rename delete old and add new - you will have to check all the tasks which used it - if it's the only one in the package then they will default to it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
smithje
Starting Member
32 Posts |
Posted - 2004-02-19 : 14:59:57
|
| DTS versions are a real pain in the Yak for those of us who save our packages as files outside of sql. The delete versions option is not available for packages saved as files and edited packages will no longer run from stored procedures because of the version issue. But since someone who makes more doe(or dri if you are a female Yak) than me decided we will have versions, we have found a "work around" for this lovely feature. Open the DTS package from its file location. Edit and save as type SQL Sever. Delete the original DTS file. Open package from the enterprise mgr Data Trans folder. Delete the old version (right click). Save the package again as a file with the original name intact. |
|
|
|
|
|
|
versions