Cloudy River's Workshop: How to deploy your SSIS packages

After you finished your SSIS packages and successfully test them, you want to deploy those packages to SQL Server and want to run the package on your SQL Server.

The first thing you need to do is to create one Integration Service Catalog, which will contain all deployed SSIS packages. Each SQL Server instance would have only one Catalog.

Open SQL Server Management Studio, Right click on Integration Services Catalogs, and choose Create Catalog, the Create Catalog Pop window will appear.

Enter catalog database name, encryption password, and choose if you want to run the Catalog.startup store procedure every time the SQL Server instance starts. The Catalog.startup store procedure would fix the status of catalog packages if these packages were executing while SQL Server went down.

After you created the Catalog, you can create one folder under it to store the deployed packages. Just right click on the Catalog Name, and choose "Create Folder".

Enter the folder name.

Under the newly created folder, there are 2 pre-defined folders: one is "Project", the other would be "Environments".

Now go back to your SSIS project, right click on your SSIS project name in BIDS, choose "Deploy",
following Project Deployment wizard will appear:

Fill the server name, and click on "Next" and then click on "Deploy".

If you don't have the required privilege to view the server, you can't deploy by this method. However, you can go to the bin folder of your SSIS project, copy the compiled SSIS project file xxx.ispac to the server manually and deploy the package on the server.

On your SQL Server, run SSMS, and choose the SSIS Catalog you just created, right click on the "Projects" directory, click on "Deploy Project". The SSIS package deployment wizard appeared.