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.
Connect a SharePoint list with external data. SharePoint Business Data List Connector (BDLC) connects any type of SharePoint 2007 / 2010 list (no Web Part) with external business data using list settings, e.g. for contacts, tasks or events. The data can be presented without any restrictions, with the full read-only and optionally write-back (Create, Update, Delete: CRUD) functionality of common SharePoint lists. Views, sorting and grouping, filters and calculated fields can all be created. BDLC can be used to connect real SharePoint lists to databases, such as MS SQL Server, Oracle, IBM DB2, MySQL, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, Informix, Postgres SQL, IBM UniData, IBM UniVerse, AS/400 (IMB iSeries), Progress, Microsoft Office data files or other SharePoint lists.