I want to deploy multiple packages into a deployment server. Can anyone explain the procedure? Thanks chinni

there are many ways to deploy create a manifest file (check the below links) http://msdn.microsoft.com/en-us/library/ms137952.aspx http://msdn.microsoft.com/en-us/library/ms141693.aspx - Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

The deployment-utility is one (probably the popular) way but I like these "one-button-" or "double-klick-things" and the work gets done... I tried "dtutil" within a Powershell-Script, running through a specific folder that holds all the packages I want to deploy. Worth the effort! http://msdn.microsoft.com/en-us/library/ms162820.aspx BR Patrick

I want to deploy multiple packages into a deployment server. Can anyone explain the procedure? Thanks chinni Se the below, and if you are using SSIS 2012 there is a project based deployment and the so called legacy deployment. Both approaches are nicely covered in details here http://datachix.com/2011/11/29/sql-university-ssis-2012-deploying-projects/Arthur My Blog