How do you deploy SSIS package From DevOps SSIS Deploy Task: Windows Auth, SQL Auth, Active Directory Integrated

Question

I've developed a DevOps Release pipeline that employs the SSIS Deploy task. The Microsoft Learn Documentation fails miserably here. There's no explanation on how to implement:

• Windows Authentication (in light of the fact you're in a DevOps pipeline where is this Windows user???)
• SQL Authentication (look up all the stackoverflows that say undocumented: unfeasible to use this option)
• Active Directory Integrated (Do they mean Entra ID?? and how exactly do we implement? do you need an email address? where do you put it?)

Answer 1

Hi @Timothy Sandberg,

Authentication type to access the specified destination server. This property is only visible when Destination type is SSISDB. In general below authentication types are supported:

• Windows Authentication
• SQL Server Authentication
• Active Directory - Password
• Active Directory - Integrated

But whether a specific authentication type is supported depends on destination server type and agent type. Detail support matrix is listed in below table.

SQL Server Integration Services (SSIS) DevOps Tools Azure DevOps extension

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.