With the Task Factory PowerShell Task, you can run PowerShell scripts in a SQL Server Integration Services (SSIS) package.
Task Factory provides dozens of high-performance SSIS components that save you time and money by accelerating ETL processes and eliminating many tedious SSIS programming tasks.
Incorporating PowerShell scripts into your ETL process using native SSIS functionality can be a challenge. With the Task Factory PowerShell Task, you can quickly and easily run PowerShell scripts directly in SSIS packages.
Dynamic PowerShell script execution with variable replacement
Save execution results to a variable to be used in down-flow components
Test scripts in the PowerShell Task UI before executing your SSIS package for rapid development
A Task Factory license is not required to use Task Factory when developing and running packages in Visual Studio/SSDT. However, a Task Factory license is required to use Task Factory for packages run outside of Visual Studio/SSDT.