Forum Discussion

ujssd's avatar
ujssd
Copper Contributor
Nov 06, 2023

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...
Azure DevOps
  • ujssd's avatar
    ujssd
    Copper Contributor
    Nov 14, 2023
    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.
    • mferla1420's avatar
      mferla1420
      Copper Contributor
      Jul 18, 2024
      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.

Resources