How to deploy the package in SSIS 2012

How to deploy the package in SSIS 2012

Integration Services supports two deployment models, the project deployment model and the package deployment model. The project deployment model enables you to deploy your projects to the Integration Services server.

Project Level deployment

In order to use the new Project Deployment Model, you need to create the Integration Services Catalog for the first time.  Otherwise you will get the following error message as:

An Integration Services catalog (SSISDB) was not found on this server instance ("LocalHost"). 
To deploy a project to this server, you must create the SSISDB catalog. Open the Create Catalog dialog box from the Integration Services node.

Steps to Create the Catalog:

    1.       Open SQL Server Management Studio

    2.       Right click on the Integration Services node

    3.       Click on the Create Catalog…..

    4.       The catalog name is SSISDB. Enter the password for encryption then hit the OK button.

   5.       The new SSISDB will be created and show in two places:

·         Database node

·         Integration Services node

   6.       You may view or adjust the catalog properties using the property window or Catalog.Configure_Catalog stored procedure.

   7.        Create a new folder under SSISDB.

   8.       Right click on the Project folder and select ‘Deploy Project’.

   9.       Integration services Deployment Wizard will be opened then click on NEXT button at the bottom.

   10.   Click on browse button to select the corresponding .ispac file

   11.   Provide the server name and locate the folder  in SSISDB where you want to deploy the package.

   12.   Click on NEXT button and then you will get the final window to deploy the project on the required server.

   13.   Once it is deployed , you can execute the package as shown below:

Note: Once you have created Integration services catalog on your server, you don’t need to go through steps 1-7.

You can deploy the package without following the steps 8-12.

Kindly follow the steps mentioned below to deploy the package to the server using .ispac file directly:

   1.       Double click on the .ispac file, one deployment wizard will be opened.

   2.       Click on NEXT button.

   3.       You will find the corresponding .ispac file already available in the browsing path. Then select NEXT button once again.

   4.       Provide the server name and locate the folder in SSISDB where you want to deploy the package.

   5.       you will get the final window to deploy the project on the required server. Select DEPLOY button now.

Deployment using environment option is SSIS catalog:

Follow the steps mentioned below:

   1.       Right click on the Environment folder under SSISDB available in Integration services catalog.

   2.       Provide an appropriate name to the environment and click on OK button to close this box.

   3.       Double click the newly declared environment and provide the details.

   4.       Click on OK button to close this box.

Now we can use this environment in the package as reference.

   5.       Right click the project folder under SSISDB and select IMPORT PACKAGE.

   6.       Provide the credentials for the package and the deployment server and use the declared environment in the reference category.

   7.       You can change the configuration afterwards also whenever you require to change it.