I am trying to follow the instructions here - https://learn.microsoft.com/en-us/sql/integration-services/ssis-quickstart-deploy-powershell?view=sql-server-ver15
I get this error: MethodInvocationException: Exception calling "Load" with "1" argument(s): "Could not load file or assembly 'Microsoft.SQLServer.Management.IntegrationServices, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL'. Operation is not supported. (0x80131515)"
Perhaps the instructions are missing a prerequisite that explains how to install something?
For additional clarification, I'm just trying to deploy an SSIS package to a server. This used to work in PS5, but isn't any longer.
With this command: [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SQLServer.Management.IntegrationServices")
In Powershell 5, I get this:
GAC Version Location
True v2.0.50727 C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SQLServer.Management.IntegrationServices\188.8.131.52__8984...
In Powershell 7, I get this:
MethodInvocationException: Exception calling "LoadWithPartialName" with "1" argument(s): "Could not load file or assembly 'Microsoft.SQLServer.Management.IntegrationServices, Culture=neutral, PublicKeyToken=null'. Operation is not supported. (0x80131515)"
How do I get PS7 to run things correctly? Do I have to install a different version of SSIS tools?
Do you have the correct VERSION of SQL Server installed on the machine that's running the code that fails?
Remember, you need version 184.108.40.206 of Microsoft.SQLServer.Management.IntegrationServices to satisfy the requirement in the [System.Reflection.Assembly]::Load() parameters.