Automate SQL Server and simplify SSIS Workflows. PowerShell SSIS Task lets you call and execute PowerShell scripts directly from within SQL Server Integration Services. PowerShell SSIS Task gives you the ability to easily process messages (both pre and post) and tabular data with PowerShell scripting. It can be used to create flexible SQL Server workflow solutions via easily configurable PowerShell scripts. When PowerShell SSIS Task is executed through SSIS workflow it executes a preconfigured PowerShell script and passes the input as a parameter. Each instance of the task on a package can define a different PowerShell script to execute.
View More