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.