March 20, 2008 at 7:17 am
Hi All
I've migrated all my DTS packages from 2000 to 2005 and I’m now in the process of changing all these DTS packages.
As the DTS packages are now in a development I don’t really want each change I make to be saved as a separate version.
So, two questions:
Is there a way of turning off the version control of legacy DTS packages?
How do you delete old versions of a particular DTS package within 2005.
There is an option within Enterprise Manager under the DTS package called “Version” that allowed deletions but this option does not seem to be available in 2005.
I suspect the only solution will be a scripted one.
Many thanks for your help.
Nick.
March 20, 2008 at 9:58 am
You're right. I haven't found a GUI option for deleting DTS package versions. All versions are stored in msdb.dbo.sysdtspackages so you can find older versions with T-SQL, something like this:
select * from sysdtspackages where name = 'packagename'
The createdate column tells you when the version was created. Just delete the ones you don't want.
Greg
March 20, 2008 at 10:31 am
Hi Greg
Many thanks for the reply.
I've managed to find the GUI option to delete DTS package versions.
The "Delete" option on right clicking the DTS package takes you into the place where you can delete old versions. (It does not delete the whole DTS package!!)
Thanks for the script, I will give that a go.
Many thanks again.
Nick.
March 20, 2008 at 10:37 am
nplace6530 (3/20/2008)
Hi GregMany thanks for the reply.
I've managed to find the GUI option to delete DTS package versions.
The "Delete" option on right clicking the DTS package takes you into the place where you can delete old versions. (It does not delete the whole DTS package!!)
Thanks for the script, I will give that a go.
Many thanks again.
Nick.
Also - the right-click, "versions" will allow you to inspect/delete versions.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 20, 2008 at 12:43 pm
Neither of those options works for me. When I select 'Delete', I don't get to choose a version to delete. The package is deleted. I don't even see a 'Versions' option when I right-click on a package.
Greg
March 20, 2008 at 5:38 pm
Greg Charles (3/20/2008)
Neither of those options works for me. When I select 'Delete', I don't get to choose a version to delete. The package is deleted. I don't even see a 'Versions' option when I right-click on a package.
That may be a 2005 vs 2000 thing. I saw DTS package and I automatically went back to EM. I will have to check a 2005 instance to see.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 21, 2008 at 9:57 am
Matt Miller (3/20/2008That may be a 2005 vs 2000 thing. I saw DTS package and I automatically went back to EM. I will have to check a 2005 instance to see.
Yeah, it's the difference between using Enterprise Manager and SSMS to manage DTS packages.
Greg
May 19, 2009 at 12:42 pm
I'm also using SQL Server 2000 and can not seem to find a way to delete old version from my DTS packages.
Also, my packages are not stored in the database itself but rather to external files. This is a corporate policy and the DBA do not allow DTS packages to be stored in the database.
Is there a way to delete these old versions or do I just have to live with them?
October 12, 2010 at 7:42 am
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply