How to Deploy SSIS Package Directly in Azure Pipeline (Embedded Package)

 Issue: How to Deploy SSIS Package Directly in Azure Pipeline.

In this article, we are going to learn how to deploy SQL Server Integration Services Package directly in the Azure Data Factory pipeline.

How To Create SSIS Package:

Open the Visual studio, in the file tab click on the new project, select the Integration Services project then name your project and click on ok 

Right Right on the package deployment and select ''convert to package deployment model''.

Next, bring the data flow task, then inside the dataflow task bring the OLEDB source and OLEDB destination and then configure both, and connect with the SQL server database.

Click on OLEDB source, in the connection manager click new, then provide the SQL Server name, select the authentication type, provide the username and password, provide the database name from where you will read the data, test the connection and then click on ok if everything goes right. 

Once our OLEDB source is ready connect it with the OLEDB destination and click on OLEDB destination and in the connection manager click on new, Provide the server name, select the authentication, provide the user name and password, select or enter a database name, test the connection and then click on ok  

Once we configured our SSIS package click on Build, then click on Rebuild solution. 

Next, Open your Azure Data Factory Studio, go to the Manage tab, click on the Integration runtimes, then click on the + New button to create a new Integration Runtime.

Select the Azure SSIS Lift and shift Existing SSIS package to execute in Azure, then click on continue.

Name your Integration Runtime, select your region, choose the node size as per your requirement, then click on continue.

Uncheck the deployment settings, then click on continue.

Select the maximum parallel nodes as per your need, then click on continue, and then finally click on Create.

Next, go to the author tab, click on Pipeline, then click on New pipeline.

Find and drag the Execute SSIS package activity, go to the settings tab, select the Azure SSIS Integration Runtime that we have created earlier, select the package location as Embedded, upload your Embedded package, select the logging level and path if you need some logs, select the domain and provide the username and password, and then click on Debug to execute your package. 

Video Demo: How to Deploy SSIS Package Directly in Azure Pipeline (Embedded Package)