When trying to deploy ispac file, getting following error - New-Object : Cannot find type [Microsoft.SqlServer.Management.IntegrationServices.IntegrationServices]: verify that the assembly containing this type is loaded.
Thanks for getting in touch! I’m unable to precisely determine the issue, though I suspect it might come down to your server not containing the SSISDB catalog (which needs to manually be created, and contains the IntegrationServices assembly). The following MIcrosoft doc page outlines how you can create this SSISDB catalog in SQL Server Management Studio or via PowerShell.
Thanks for the response. In my scenario, there is an intermediate server(tentacles installed) between octopus server and the target server i.e. SQL Server(already contains SSISDB catalog). And [Deploy ispac SSIS project from a package] library runs on intermediate server(I’m assuming here, powershell script makes a remote call to target server). So my question is, what are all required to be installed on the intermediate server?
Thanks for following up! It’d be a bit of a pain to have to install SQL Server on the intermediate machine, but I believe it should work if you install just the IntegrationServices assembly to the GAC on this machine. The following thread on Microsoft’s support page I think answers how to do this.