SSIS deployment through powershell 7

Oblio 1 Reputation point

I am trying to follow the instructions here -

I get this error: MethodInvocationException: Exception calling "Load" with "1" argument(s): "Could not load file or assembly 'Microsoft.SQLServer.Management.IntegrationServices, Version=, 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\

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

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

    SQL Server Version Assembly Version Number
    SQL Server 2005
    SQL Server 2008
    SQL Server 2008 R2
    SQL Server 2012
    SQL Server 2014
    SQL Server 2016
    SQL Server 2017

  2. Oblio 1 Reputation point

    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

    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:

    Hope this helps with your query,

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