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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Remove DTS version history

Author  Topic 

p.shaw3@ukonline.co.uk
Posting Yak Master

103 Posts

Posted - 2007-07-05 : 06:41:42
Hi,

Can anyone tell me the best way to remove some of the version history from a DTS Package? I could go into MSDB/sysdtspackages and manually remove the unwanted rows, but I am unsure whether this is a good way or not.

Thanks.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-05 : 12:19:25
Or you can delete from package's versions page.
Go to Top of Page

p.shaw3@ukonline.co.uk
Posting Yak Master

103 Posts

Posted - 2007-07-06 : 01:59:29
I was using the DTS in SSMS as opposed to EM and you cannot get to the version history from SSMS.

I opened in EM and did as you suggested.

Thanks rmiao
Go to Top of Page
   

- Advertisement -