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=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL'. Operation is not supported. (0x80131515)"
Perhaps the instructions are missing a prerequisite that explains how to install something?
--edit--
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\13.0.0.0__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?