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.
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.
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.
Select Source: This page is used to specify the source path
- Project deployment file: Please specify the system path where the project file located.
From the below screenshot you can see, we are selecting the Event handling project file of type .ispac
Please cross-check all the options
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.
Here, we are selecting the named instance PRASAD.
Please cross-check all the information, and if you find anything wrong, use the Previous button to go back.
The results page will show the result. As you can see, we have successfully deployed the SSIS package to SQL Server.
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.
You can Execute the package by right-clicking the Event Handlers in SSIS Package, and select Execute.. option from the context menu
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.