Solved

How to remove previous versions of DTS packages on SQL 2005?

Posted on 2008-06-12
5
1,372 Views
Last Modified: 2013-11-30
I've recently upgraded to SQL 2005.  Using the legacy tools, I have a DTS package that I made changes to.  Now there are multiple versions of that DTS package.   In 2000, you could just right click on the DTS package, choose 'Versions', and remove the older versions.   I'm not seeing anywhere to do this in 2005.

Can you please let me know how to remove the older versions of the DTS packages?

Thank you.
0
Comment
Question by:colorbok
  • 3
  • 2
5 Comments
 
LVL 2

Accepted Solution

by:
cm0605 earned 125 total points
ID: 21769869
You can use the procedure:
EXEC msdb.dbo.sp_drop_dtspackage @name = '',
                                                            @id = ,
                                                            @versionid =
The name, id and versionid can be found in the msdb.dbo.sysdtspackages table.

Chad
0
 

Author Comment

by:colorbok
ID: 21770378
I don't want to execute it, I want to remove the old versions.
0
 

Author Comment

by:colorbok
ID: 21770387
Sorry, didn't read the code close enough.....I'll try that out and see how it works.    So you don't know of anyway to do it via the Studio interface???
0
 
LVL 2

Expert Comment

by:cm0605
ID: 21771287
The best solution I have for you is to create an SSIS package and do away with the dts package.

Chad
0
 

Author Closing Comment

by:colorbok
ID: 31466559
Thank you!!!
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now