How to deploy packages to sql server 2005

I'm still getting used to SSIS and I'm wondering how to deploy all 20 of my ssis packages to my sql server 2005 machine in the msdb?

I could open each one and then save a copy as, but by default it doesn't put the name of the package in so I must copy and paste.

thanks.

Any particular reason for using MSDB?

I used it and found it painful for the exact reason you stated.
Now I use the file system with a stand structure for each package.
\Root\
MyPackage
Bin
ConfigFiles
Logfiles
CheckPoint
RawFiles.

Simplier to manage.|||

There are great reasons to use SQL Server for deployment - in particular you can manage security on your packages easily with roles, and you can back up your packages with your databases.

Have a look at http://msdn2.microsoft.com/en-us/library/ms137592.aspx and http://msdn2.microsoft.com/en-us/library/ms137900(SQL.90).aspx (Please rate BOL content by voting and commenting at the foot of each topic.)

However, file system deployment is good too. I suggest researching in BOL and assessing what is best for your business cases.

Donald

|||

After an all nighter 11pm and a few hours today I finally realized that all that I needed to do was select the option to password protect the package. This seems to of worked.

Thanks for all your help Donald.