Screenshot Preview

PowerShell SSIS Task

by PowerShellInside - 상품타입: Component / DLL

제품 리뷰의 한국어 번역이 완료되지 않는 제품은 Google통역 서비스와 연동되어 표시되어 있습니다.통역 기계에 의한 자동 번역인 관계로 한국어 표기가 조금 부자연 스러운 점 양해 바랍니다.

  에서 제공
주의 : 별도의 안내가 없는 경우에는 영어제품 입니다.


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:

  • Fast prototyping and POC creation.
  • Eliminating redeployment headaches typically involved with changing SSIS Workflows.
  • Preprocessing and/or normalizing datasets before passing to other SSIS Tasks
  • Rapidly creating custom SSIS Tasks with the full power of PowerShell.

Using the PowerShell SSIS Task - To use the PowerShell SSIS Task, follow these simple steps:

  • Open your SSIS package in the Visual Studio designer
  • Drag the PowerShell SSIS Task Receive Task task from the Toolbox into your package
  • Configure the task properties

Configure PowerShell SSIS Task

  • The PowerShell script to run when the task is executed. You can just write your script directly in the task properties, or dot-source an external script file with your commands.
  • Zero or more input variables that you want to be defined in the PowerShell Runspace when the script is executed. You can use this to pass data from SSIS to your PowerShell script.
  • The name of a variable to output the data returned by the script. This should be an Object variable that will receive an ADO.NET DataTable containing one row for each PSObject returned by the script, with each column holding the value of a property of said object. If the script returns primitive .NET values, like an int or a string, the __Value__ column will contain its value.

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:

  • Host: The name or IP address of the remote computer.
  • Protocol: set to prRemoting;.
  • User and Password: Optional. If not specified, the connection will be attempted using the user the SSIS workflow is running under.

To use PowerShell Server, you need to have PowerShell Server installed and running in the remote machine, and configure the following properties:

  • Host: The name or IP address of the remote computer.
  • Protocol: set to prSSH.

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.

  • User: The username to be used for authentication.
  • Password: Optional. The host key/certificate used to authenticate the server.
  • SSHCert: The certificate to use for public key authentication.


검색어를 입력해주세요:

IT 전문가를 위한 소프트웨어 쇼핑몰

개발처 공식 유통업체인 ComponentSource는 애플리케이션 개발 및 운영을 전문으로 하는 250여개의 소프트웨어 제품들을 편리하게 검색하고 구매 할 수 있는 서비스를 제공합니다.

상세 | About Us