Deploying Multiple packages in a server
I want to deploy multiple packages into a deployment server. Can anyone explain the procedure?
Thanks
chinni
August 8th, 2012 7:29am
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/
Free Windows Admin Tool Kit Click here and download it now
August 8th, 2012 7:37am
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
August 8th, 2012 10:13am
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
Free Windows Admin Tool Kit Click here and download it now
August 8th, 2012 10:14am
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
August 8th, 2012 10:22am