by PowerShellInside - 상품타입: Component / DLL
Automate SQL Server and simplify SSIS Workflows. PowerShell SSIS Task lets you call and execute PowerShell scripts directly from within SQL Server Integration Services. PowerShell SSIS Task gives you the ability to easily process messages (both pre and post) and tabular data with PowerShell scripting. It can be used to create flexible SQL Server workflow solutions via easily configurable PowerShell scripts. When PowerShell SSIS Task is executed through SSIS workflow it executes a preconfigured PowerShell script and passes the input as a parameter. Each instance of the task on a package can define a different PowerShell script to execute.
PowerShell SSIS Task is perfect for:
Using the PowerShell SSIS Task - To use the PowerShell SSIS Task, follow these simple steps:
Configure PowerShell SSIS Task
Executing Scripts on Remote Machines
PowerShell SSIS Task also allows you to execute scripts on remote machines using the PowerShell V2 Remoting protocol or the PowerShell Server protocol. To use PowerShell Remoting, you need to set the following options in the task properties:
To use PowerShell Server, you need to have PowerShell Server installed and running in the remote machine, and configure the following properties:
SSHAuthMode: Set to amPassword for username/password authentication or to amPublicKey for public key authentication. For the latter, this option needs to have been enabled in the remote PowerShell Server, and the task needs to have access to a certificate the server will accept.