Can I make a Backup of DTS packages? 1

[ericnet]

Hello,

Weekly I make a database backup from Enterprise Manager (right click to databaseName and I choose the option to make a copy to a CD). But now I want also to make a copy/backup of my DTS packages, Is this possible? If so, which are the steps to do it?

Thanks

 

[SQLDenis]

backup the msdb DB or save the packages as Structured Storage Files
to see how to save packages as Structured Storage Files
go here:

http://sqlservercode.blogspot.com/2006/10/saving-dts-package-on-another-server.html

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ericnet]

Ok, I see, that it' s interesting, and which practice you recommend me? (msdb DB backup or save the packages as Structured Storage Files) the last one seems lighter..

 

[ericnet]

It doesn’ t matter, I recommend me myself Structured Storage Files, because I don’ t have more time now. Anyway thank you for your answer!