SSIS Project Deployment Using SQL Deployment Wizard

In this article, we show you the ideal approach to SSIS Project Deployment using SQL Deployment Wizard with example. For this SSIS Project Deployment using SQL Deployment Wizard demo, we are going to use the following Integration Service project. As you can see, it has the only package that we created earlier.

We already explained this package in Deploy SSIS Package using BIDS, and I suggest you refer the same. Before you start deploying the SSIS project, you have to build the project. For this, please navigate yourself to the Solution Explorer window. Here, right-click on the Project and select the Build option from the context menu.

SSIS Project Deployment Using SQL Deployment Wizard 1

Now you can see the project build in Documents -> Visual Studio (version) -> Projects -> project Name -> Bin -> Development folder.

SSIS Project Deployment Using SQL Deployment Wizard 2

SSIS Project Deployment Using SQL Deployment Wizard

To deploy the SSIS project using SQL Deployment Wizard, please find the SQL Server Deployment Wizard (version may be different). For me it is in C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2014\Integration Services

SSIS Project Deployment Using SQL Deployment Wizard 3

Once you double-click on the SQL Server Deployment Wizard, a new window called Integration Services Deployment Wizard will open. It is an introduction page, and click the Do not Show this Page Again to avoid this page.

SSIS Project Deployment Using SQL Deployment Wizard 4

Select Source: This page is used to specify the source path

  • Project deployment file: Please specify the system path where the project file (our newly built file) located.
SSIS Project Deployment Using SQL Deployment Wizard 5

From the below screenshot you can see, we are selecting the Load Data project that we build previously

SSIS Project Deployment Using SQL Deployment Wizard 6

Select Destination: This page is used to specify the destination. Here, we chose the named instance PRASAD. Next, you can select the existing folders under the SSISDB catalog as the project path.

For now, we will create a new folder by clicking the New Folder.. button.

SSIS Project Deployment Using SQL Deployment Wizard 7

As you can, we assigned Load Data to our new folder

SSIS Project Deployment Using SQL Deployment Wizard 8

Click Next button

SSIS Project Deployment Using SQL Deployment Wizard 9

Please cross-check all the information, and if you find anything wrong, then use the Previous button to go back.

SSIS Project Deployment Using SQL Deployment Wizard 10

The results page will show the result

SSIS Project Deployment Using SQL Deployment Wizard 11

Let me open the SQL Server Management Studio, and please navigate to Integration Services Catalog -> SSISDB -> Load Data -> projects under the Object explorer will show the newly deployed project.

SSIS Project Deployment Using SQL Deployment Wizard 12