Task Factory PowerShell Task
| Task Icon | Task Description |
|---|---|
|
|
The PowerShell Task is a control flow component that executes a user-entered PowerShell script. Use the PowerShell Task to run PowerShell scripts directly in your SSIS package. |
PowerShell Command
| Component | Description |
|---|---|
| Command Window | Enter the PowerShell command you want to execute. Note: Variable replacements can be used with the following syntax: <@User::VariableName> |
| Object Variable To Save Execution Results To | Select the Object Variable used to save your task execution results. Note: You can only select this option if your object is a datatype. |
| Test Script | Select Test Script to display the Execution Output and Results Object Explorer data for the entered script. |
Script Results
| Component | Description |
|---|---|
| Execution Output | Displays any execution messages associated with your PowerShell script (error messages, warnings, etc.). |
| Results Object Explorer | Displays the sample results of your PowerShell script. |
Additional Information: For information about using PowerShell Commands in SSIS, see the PowerShell MSDN documentation.