Task Factory Feature:

PowerShell Task SSIS Component

Execute PowerShell Scripts in SSIS Packages

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.

Get Started with Task Factory

Task Factory Buying Options

Learn More

Try Task Factory for Free

Download Free Trial

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 Buying Options

Contains dozens of tasks, connection managers, sources, and destinations for SSIS.
Task Factory does not require a license while you're running packages in Visual Studio.

Compare Editions

Standard

Annual Subscription License

$895

Per Server
Includes annual maintenance

Buy

30+ SSIS tasks and components

Contact us for perpetual licensing options.

Pro

Annual Subscription License

$1,245

Per Server
Includes annual maintenance

Buy

70+ SSIS tasks and components

Contact us for perpetual licensing options.

Azure Data Factory

Annual Subscription License

$1,495 

Per ADF Node

 
Buy