Saturday, November 17, 2012 11:27 AM
I have a project with more than one package,How to deploy single package to production environment in SSIS projects?
thanks and regards
- Edited by samba cheedella Saturday, November 17, 2012 11:46 AM
Sunday, November 18, 2012 1:45 AM
Not sure of a way to deploy a single package from within BIDS but you can deploy it using other means. The options depend on how you plan on storing your packages.
- If you are planning on using the file system locate package through windows explorer, then copy and paste it in the location you wish to store it in production. The default production storage location can be determined by looking at the MsDtsSrvr.ini.xml file found here (If you installed SQL Server 2008 with defaults) %ProgramFiles%\Microsoft SQL Server\100\DTS\Binn. If you copy your package file in the default location it will then be listed under the SSIS File system folder when you connect to the SSIS intance in SQL Server Management Studio.
- If you are planning on storing it directly in SQL server then open SSIS in SQL Server Management Studio right click on the MSDB folder and select import. In the import package window select file system in the Package Location drop down, in the Package path browse to the package location through the file system and select it. Choose your protection level and click ok. This SQL Server Performance article walks you through the steps.
Sunday, November 18, 2012 12:39 PM
Right click on the SLN and at the opened window pick the 'DeploymentUtility' and check what is the path at the 'DeploymentOutputPath' . Mine is 'bin\Deployment' .
Another Right click on the SLN and now we will build the solution .
Go to solution's path and dive into the 'DeploymentOutputPath' . See the SSISDeploymentManifest file ? click it and just pick the way to deploy . Don't Forget - Mark the 'Rely on Server Storage for encryption' check box while you're configuring the deployment .
Tip : This way will deploy all the packages under the 'bin\Deployment' folder, so if you want just some of them, sort the packages in the folder by their modification and delete all the unrellevant packages (it will only delete it from the Deployment file and not from the sln folder) .
Another easy way (if you have hust some ...) will be File-->Save Copy of NAME As and then Copy and paste the package Name and deploy it as a file system or SQL. copy and paste is important so you will not create a new package by accident .
Please vote as helpful or mark as answer if it helps :) Regards, David .
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Friday, November 23, 2012 8:30 AM