Build And Deploy Ssis Packages Using Vsts

I created the simple SSIS project in VS2015 with SQL Server 2012 as a targeted server, it will worked in local machine successfully without any issues. After that I have created th

Solution 1:

Based on the source code, the connection uses windows authentication (Integrated Security=SSPI), but the Hosted agent uses service account, so it can’t connect to the server.

You can refer to the source code to build the PowerShell script to deploy SSIS project and the project name is the name of the SSIS project. (Using SQL Server authentication: User ID=XXX;Password=XXX)

Another article with the code about deploying SSIS: Deployment Automation for SQL Server Integration Services (SSIS)