Deploy SSIS Package Using SQL Server

In this article, we will show you the step by step approach to deploying the SSIS package using SQL Server or Integration Services Catalog.

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

Deploy SSIS Package Using SQL Server 1

How to Deploy SSIS Package Using SQL Server

To Deploy SSIS Package Using SQL Server, right-click on the Projects folder, and select the Deploy Project.. option.

Deploy SSIS Package Using SQL Server 2

Once you select the Deploy Project.. option, a new window called Integration Services Deployment Wizard will open. It is an introduction page, and by clicking the Do not Show this Page Again, you can avoid this page.

Deploy SSIS Package Using SQL Server 3

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

  • Project deployment file: Please specify the system path where the project file located.
Deploy SSIS Package Using SQL Server 4

From the below screenshot you can see, we are selecting the Event handling project file of type .ispac

Deploy SSIS Package Using SQL Server 5

Please cross-check all the options

Deploy SSIS Package Using SQL Server 6

Select Destination: This page is used to specify the destination to Deploy SSIS Package Using SQL Server

  • Server Name: Please specify the SQL Server instance. Here it will automatically select the default instance localhost because we started this wizard using this instance. But you can change it to Named instance that you use to access databases.
  • Path: You have to specify the Integration Service catalog path. If you haven’t created a catalog, please refer to Create SSIS Catalog article to understand the steps.
Deploy SSIS Package Using SQL Server 7

Here, we are selecting the named instance PRASAD.

Deploy SSIS Package Using SQL Server 8

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

Deploy SSIS Package Using SQL Server 9

The results page will show the result. As you can see, we have successfully deployed the SSIS package to SQL Server.

Deploy SSIS Package Using SQL Server 10

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

Deploy SSIS Package Using SQL Server 11

You can Execute the package by right-clicking the Event Handlers in SSIS Package, and select Execute.. option from the context menu

Deploy SSIS Package Using SQL Server 12

TIP: We already explained the Execution process in our previous article. So, please refer to Deploy SSIS Package using BIDS article to understand those steps.