Execute SSIS Package from PowerShell

You may also like...

2 Responses

  1. gbargsley says:

    This is awesome. I was just looking to solve this last week.

    Do you have any hints or tricks on how to move a package from one SSIS server to another SSIS server with Powershell?

    • Aaron Nelson says:

      Gary,
      I’m glad you like it! As of right now, the only “hint” I have for “how to move a package from one SSIS server to another SSIS server with PowerShell” is to point you to the Docs page that shows you “Deploy an SSIS project with PowerShell”. Unfortunately, the example in this page only covers how to deploy via an .ispac file. However, if you know some .NET, or know a .NET developer, you might be able to come up with something even better!
      https://docs.microsoft.com/en-us/sql/integration-services/ssis-quickstart-deploy-powershell

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: