Task Factory Feature:

PowerShell Task SSIS Component

Execute PowerShell Scripts in SSIS Packages

With the SolarWinds 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.

Download Free Trial

Learn More About Task Factory Pricing

Task Factory

Includes 60+ high-performing SSIS components that help you efficiently manage ETL pipelines. Learn More

 

Task Factory Azure Data Factory 

Includes 65+ high-performing SSIS components that help you efficiently manage ETL pipelines in Azure Data Factory (ADF). Learn More
 

Task Factory PowerShell Task

 

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.

Component Highlights

  • 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

Task Factory Licensing Options

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.

Compare Editions

Task Factory

Annual Subscription License

$1,245

Per server
 

65+ SSIS tasks and components

Task Factory
Azure Data Factory

Annual Subscription License

$1,495 

Per ADF node
 
 65+ SSIS tasks and components