Create Build/Release Pipeline for SSIS in Azure SQL server

Create a new pipeline in devops.

Select the source:

Select an empty template

Select Get Sources in the left panel:

Now add a new agent job to Build SSIS. Click the + icon.

Search for SSS job. (if it's not already installed, then first install it from the marketplace)

Add SSIS build and then add SSIS Deploy 

Once you add these two jobs, your screen should look like this:

Now Select Build SSIS:

in the Project Path field, select the directory where .sln file is located. 

Leave the rest of the fields as default.

Now Select Deploy SSIS job to configure deploying settings 

add source path = $(Build.ArtifactStagingDirectory) (i.e. output path value from Build SSIS job-Previous step).

select destination type = SSISDB.

Destination Server = realdatabaseserver01.database.windows.net

Destination Path = /SSISDB/masterdatahub

Authentication type = SQL Server Authentication (you can choose any other option as per your need)

Click on the Triggers tab and configure Continuous Integration. 

Now Save and Queue the Pipeline. 

Once released you will see the ssis package under masterdatahub folder

That's everything for Azure devops continuous integration/ continuous deployment process for releasing ssis project to azure sql server. Good luck!

Fix for SSIS not picking correct configuration file

When there are more then one configuration file for a single package, the SSIS jobs sometimes do not automatically pick the correct configuration depending on how the settings has been made. 

In the SSIS package (using Visual Studio) Make sure you've done following correctly:

1) In the package property, Set Delay Validation =  false
2) Uncheck , Enable Package Configuration. 


steps for 2):

a) open the ssis package in visual studio.

b) In the Control flow tab, right click on the blank space of the canvas.

c) go to Package Configurations...

d) uncheck Enable Package Configuartion and press Close.

e) Save the ssis package and copy that to the deployed folder.