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

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.
colorbokAsked:
Who is Participating?
 
cm0605Connect With a Mentor Commented:
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
 
colorbokAuthor Commented:
I don't want to execute it, I want to remove the old versions.
0
 
colorbokAuthor Commented:
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
 
cm0605Commented:
The best solution I have for you is to create an SSIS package and do away with the dts package.

Chad
0
 
colorbokAuthor Commented:
Thank you!!!
0
All Courses

From novice to tech pro — start learning today.