There have been some rather significant changes made to SSIS in SQL Server 2012. One of which is package deployment. In 2005 and 2008, one could easily deploy packages to the MSDB. In 2012, this has been changed. Before you can deploy anything, there has to be an integration services catalog.

Here are the steps to deploying a project in SQL Server 2012 for the first time.

Right click on the Integration Services Catalogs node, and select? Create Catalog?.


This opens a window with a set of options to create the catalog. Be sure to first enable CLR Integration and then create a password for the encryption key.


Click ?OK? and the SSISDB is added.


You can now select the root of your SSISDB catalog.

Right Click ?New Folder? and create a folder to which you can deploy the project.


Click ?OK? and now select the new folder.


Open project folder and right click for project deployment


Deploy project will open Integration Services Deployment Wizard.

Click on next


Click the browse button to select a project /bin folder path (/bin/Development/file.ispac)


Click on next


Click on next
The ?Review? screen will give a summary of what will be deployed, and how.


Click ?Deploy? to deploy the entire project. Once deployment is complete, the deployment wizard will display a results page.


Close the wizard and go back to management studio. Refresh the object explorer window. Expand the SSISDB and all the folders that are created below that. The packages are visible in the packages folder underneath the project name.


After deployment of SSIS project respective package default parameters values can be verified in “[internal].[object_parameters] ”table In SSISDB .



Bhagwan Singh Jatav

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook