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.

Deploy SSIS Package Using SQL Server; let me open the Management Studio. Next, please navigate to Integration Services Catalog -> SSISDB -> Deploying Projects -> Projects under the Object Explorer will show the newly deployed project.

Object Explorer 1

How to Deploy SSIS Package Using SQL Server

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

Deploy SSIS Package Using SQL Server 2

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

Integration Services Wizard First page 3

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

  • Project deployment file: Please specify the system path where the project file is located.
Choose the Source path 4

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

Choose the Package for file system 5

Please cross-check all the options.

After. the path has chosen click the next button 6

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

  • Server Name: Please specify the instance. Here it will automatically select the default instance localhost because we started this wizard using this instance. But you can change it to the 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 Catalog article to understand the steps.
Deploy SSIS Package Using SQL Server 7

Here, we are selecting the named instance PRASAD.

Browse For Instance 8

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

Review Integration Services Wizard Settings 9

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

Click the Close button 10

Let me open the 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 selecting Execute.. option from the context menu.

Execute the Package 12

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