sql server dts: Hello..

I have been playing around and creating test SSIS packages in my development
2005 environment. I have saved the packages to MSDB. I am now ready to
start creating useful SSIS packages. How can I delete the old SSIS packages
from MSDB in SQL Server 2005?

Please advise...

Thanks,

Brett

You must connect to the Integration Services Server.

In Management Studio, in the Object Explorer click connect - > Integration
Services. Then supply the information (the server and connection
credentials, remember there is only one IS Service per box).

Then navigate to Stored Packages -> MSDB

Then right click on your package and select delete.

Note: IS does not store old versions of your package. Whereas DTS stored all
of your old versions, unless you deleted them. With IS the package.dtsx file
is an XML file and is easily stored inside of a version control system (very
easily considering that BIDS is really VS.NET, which integrates quite
nicely, with SourceSafe, VS Team System, SourceGear Vault, etc.)

--
David Lundell
Principal Consultant and Trainer
www.MutuallyBeneficial.com
David@MutuallyBeneficial.com
[quoted text, click to view]