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.
Step2 : Enable CLR Integration and provide encryption password.
Step3 : You will find SSISDB catalog will created. Creating catalog automatically creates database “SSISDB” to your instance.
Step4 : Now go to your package right click on your project and select “Deploy”.
Step5 : Selection will opens deployment window click on “next”.
Step6 : Provide destination server detail to server name.
Step7 : Click on “Browse” to select Path:
Create New folder with your desired name.
Step8 : Click on “Next”.
Step9 : Check the summary and click on “Deploy”.
Step10 : Click on “Close”.
Step11 : Check your deployed package under Integration service in SSMS.
Step12 : To Schedule this package create new job with name “Deployment Testing”.
–> Select “SQL Server Integration Services Package’ in Type.
–> Select “SSIS Catalog” in Package Source and provide server connection details.
–> Select your package path.
–> Schedule the package as your desired time.