SSIS DevOps Tools error
I installed the SSIS DevOps Tools in my Azure DevOps instance so I can use Pipelines & Release to build SSIS Projects on my on-premises self-hosted agent (SHA) and deploy them to my on-premises SQL S...
Forum Discussion
Our "fix" after talking with support required Visual Studio 2022 Community Edition to be installed on the self-hosted agent. All is working as it should now.
- Weird fix, since I expect to get dependencies from the SSIS Deploy task itself, why do we have to install Visual Studio 2022 Community Edition.
I ran into the same issue, I use Windows Auth with Microsoft Managed Service Account the service has SSIS permission from Component Services and ssis_admin + db_owner in SQL.
As "workaround" I had to create the folder first, but it is not my preferred way and it should create the folder as mention in the documentation.