In this article we will show you the ideal approach to deploy SSIS project using SQL Deployment Wizard with example. For this demonstration we are going to use following Integration Service project. As you can see, it has one and only package that we created earlier. We already explained this package in Deploy SSIS Package using BIDS, and I suggest you to refer the same.
Before you start deploying the SSIS project, you have to build the project. For this, please navigate yourself to Solution Explorer window. Here, right-click on the Project, and select the Build option from the context menu.
Now you can see the project build in Documents -> Visual Studio (version) -> Projects -> project Name -> Bin -> Development folder.
How to Deploy SSIS Project Using SQL Deployment Wizard
In order to deploy SSIS project using SQL Deployment Wizard, please find the SQL Server 2014 Deployment Wizard (version may be different). For me it is in C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2014\Integration Services
Once you double-click on the SQL Server 2014 Deployment Wizard, a new window called Integration Services Deployment Wizard will be opened as we shown below. This is an introduction page, and by clicking the Do not Show this Page Again, you can avoid this page.
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) is located.
From the below screenshot you can see, we are selecting the Load Data project that we build previously
Select Destination: This page is used to specify the destination. Here, we selected 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.
As you can, we assigned Load Data to our new folder
Click Next button
Please cross check all the information, and if you find anything wrong then use the Previous button to go back.
Results page will show the result
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.
Thank You for Visiting Our Blog