Deploy SSIS Package in SQL Server 2012

Deploy SSIS Package in SQL Server 2012.

SQL Server 2012 added new feature of Integration Service Catalog, which makes SSIS package deployment task very easy.

To get advantage of this feature you must have sql server integration service installed on your server.

Follow the steps to deploy package.

Step1 : Create Integration Service catalog.

DeploySSISPackage1

Step2 : Enable CLR Integration and provide encryption password.

DeploySSISPackage2

Step3 : You will find SSISDB catalog will created. Creating catalog automatically creates database “SSISDB” to your instance.

DeploySSISPackage3

Step4 : Now go to your package right click on your project and select “Deploy”.

DeploySSISPackage4

Step5 : Selection will opens deployment window click on “next”.

DeploySSISPackage5

Step6 : Provide destination server detail to server name.

DeploySSISPackage6

Step7 :  Click on “Browse” to select Path:

DeploySSISPackage7

Create New folder with your desired name.

DeploySSISPackage8

Step8 : Click on “Next”.

DeploySSISPackage9

Step9 : Check the summary and click on “Deploy”.

DeploySSISPackage10

Step10 :  Click on “Close”.

DeploySSISPackage11

Step11 : Check your deployed package under Integration service in SSMS.

DeploySSISPackage12

Step12 : To Schedule this package create new job with name “Deployment Testing”.

DeploySSISPackage13

–> Select “SQL Server Integration Services Package’ in Type.

–> Select “SSIS Catalog” in Package Source and provide server connection details.

DeploySSISPackage14

–> Select your package path.

DeploySSISPackage15

–> Schedule the package as your desired time.

DeploySSISPackage16

 

Regards,

Nirav Gajjar