It can be confusing to know which tool in the SSIS toolbox to use when trying to execute a PowerShell script from within SSIS.

The best task to use is an Execute Process Task. Under General you can give it a name and a description.

On the process section you fill in all the necessary details. Such as Executable, Arguments and Working Directory.

Once this is complete you can then execute your PowerShell script from within SSIS.

3 thoughts on “Run a PowerShell Script from SSIS

  1. Pingback: Executing Powershell From SSIS – Curated SQL

  2. It is very useful. May I ask what is -F on the Arguments field in the Execute Process Task Editor? Any resource to show the parameters we can use on the Arguments field? Thank you.

Leave a Reply

Your email address will not be published. Required fields are marked *

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