PowerShell SSIS Task now available

PowerShell SSIS Task lets you automate SQL Server and simplify SQL Server Integration Services workflows.

Zoom [+]

Editing a control flow with PowerShell SSIS Task.

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 pre/post-process messages 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.

Features

The PowerShell SSIS Task is ideal 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
• PowerShell SSIS Task also allows you to execute scripts on remote machines using the PowerShell V2 Remoting protocol or the PowerShell Server protocol

About PowerShellInside

PowerShellInside is a division of /n software inc. (www.nsoftware.com) a leading provider of software components for communications, security, and e-business. Since 1994 /n software has established itself as a leading provider of cross-platform software components for communication, security, and e-business development.  /n software is committed to providing enterprise-class tools and components enabling developers to rapidly build robust Internet enabled Web and desktop applications.