SSIS Package Deployment

Suppose there is a simple sample package with a Data Flow task, having a DataSource, a Conditional Split and a Data Destination like the one shown in the image below.

The name of the package is SSIS_Sample.dtsx.

Before we start accessing the package you need to deploy it to a directory or SQL Server.

Deployment of SSIS Package:

Step 1: Right click on the package solution and choose properties.

In the properties window make sure the option CreateDeploymentUtility is set to True under the Deployment Utility section.

Step 2: Now build your SSIS solution.

Step 3: Go to the \bin\Deployment folder inside the folder where you created the SSIS solution. There you will find an SSIS deployment manifest file.

Step 4: Run the file and follow the instructions.

Choose the SQL Server Deployment option

Provide the Database Server details and click on the button next to “Package path”. In this example I am using my local server and Windows authentication.

Click Next and provide the folder path for deploying any of the dependencies like configs etc.

Click Next…

Congratulations your package is deployed and is ready to be used.