SSIS deployment through powershell 7

Oblio 1 Reputation point
2022-02-08T20:59:11.74+00:00

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?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,521 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,455 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Rich Matheisen 45,831 Reputation points
    2022-02-08T22:25:39.503+00:00

    Version 14.0.0.0 is part of SQL Server 2017. Is that what you have installed on your machine?

    SQL Server Version Assembly Version Number
    SQL Server 2005 9.0.0.0
    SQL Server 2008 10.0.0.0
    SQL Server 2008 R2 10.0.0.0
    SQL Server 2012 11.0.0.0
    SQL Server 2014 12.0.0.0
    SQL Server 2016 13.0.0.0
    SQL Server 2017 14.0.0.0


  2. Oblio 1 Reputation point
    2022-02-09T01:04:51.41+00:00

    Right, so, again: I have to have all of SQL Server installed on my workstation in order to deploy an SSIS package to the SQL Server that will be running it?

    Like, imagine I check out a solution from version control with the package I want. I then want to build and deploy it to an instance of SQL. Are you saying I can't do that unless I ALSO have SQL installed on my workstation?


  3. Limitless Technology 39,501 Reputation points
    2022-02-14T15:58:27.757+00:00

    Hello @Oblio

    There is a known issue in SQL Server 2016, for the error 0x80131515 on SSIS. If that is your version, please check the next KB article:

    https://support.microsoft.com/en-us/topic/kb4134601-fix-could-not-load-file-or-assembly-microsoft-analysisservices-adomdclientui-error-when-a-process-full-operation-is-run-in-sql-server-55ccd19d-24e6-7255-cd16-3a96aabe9418

    Hope this helps with your query,

    --
    --If the reply is helpful, please Upvote and Accept as answer--