Browse by Tags

Running multiple SSIS Foreach Loops in parallel

Published 11 August 10 11:0 AM | dougbert

The Parallel Loop Task , recently released in beta by Cozyroc Software , " can execute multiple iterations of the standard Foreach Loop Container concurrently. In tests, a CPU intensive sequential process when executed in parallel on 4-core machine...

Filed under: third-party products, custom components, vendors

Running PowerShell tasks from an SSIS task

Published 11 August 10 10:39 AM | dougbert

In an earlier blog post , I noted that there hasn't been much buzz about performing SSIS-related tasks with Windows PowerShell. But what if you want to perform PowerShell tasks with SSIS? A PowerShell Task for SSIS was released recently just for this...

Filed under: third-party products, custom components, vendors, PowerShell

SSIS with Dynamics CRM: Case study from a large bank

Published 16 June 10 9:46 AM | dougbert

Two years ago, I wrote a short blog post here about using SQL Server Integration Services (SSIS) with Microsoft Dynamics CRM . There are 2 ways that you can work with CRM programmatically: The supported way, through the Web services API that the application...

Filed under: third-party products, CRM, custom components, vendors

New Excel components out in beta from Cozyroc

Published 8 June 10 3:41 PM | dougbert

Yesterday (6/7/2010), Ivan Peev of Cozyroc announced the beta release of version 1.5 of SSIS+, Cozyroc's suite of custom components for SQL Server Integration Services . The new components for Excel in SSIS caught my attention. The announcement summarizes...

Filed under: Excel, third-party products, custom components, vendors

More SSIS and spatial, with an offer from SAFE Software

Published 23 April 10 1:26 PM | dougbert

An offer from SAFE software, "The Spatial ETL Experts" In my recent blog post where I mentioned some components and resources for using SSIS with geospatial data, naturally I mentioned the extensive set of custom components available from SAFE...

Filed under: Codeplex, third-party products, custom components, books, vendors, spatial

CDC for heterogeneous sources with SSIS, from Attunity and Microsoft

Published 3 November 9 11:20 AM | dougbert

See the press release from yesterday (11/2/2009): Attunity extends its partnership with Microsoft to enable heterogeneous Change Data Capture Some excerpts: The solution, based on Microsoft’s SQL Server Integration Services (SSIS) and Attunity’s...

Filed under: third-party products, vendors, cdc

Updated product: EBCDIC Source component "Lysine" from Amino Software

Published 23 September 9 3:10 PM | dougbert

Patrick & Ben at Amino Software have announced a new version of "Lysine," an Integration Services source component for loading EBCDIC data into the data flow of an SSIS package. I wouldn't know an EBCDIC if one ran up and bit me, so...

Filed under: ebcdic, third-party products, vendors

Import EBCDIC in SSIS packages with updated Lysine 1.1

Published 20 February 9 7:40 AM | dougbert

You can now import EBCDIC data more reliably in SQL Server Integration Services packages with version 1.1 of "Lysine", just announced by Patrick & Ben at Amino Software . If you work with EBCDIC dta, what's in it for you? "The major...

Filed under: ebcdic, third-party products, vendors

MSDN publishes first 2 articles by Integration Services product vendors

Published 21 October 8 4:14 PM | dougbert

MSDN/TechNet has just published 2 new articles by third-party vendors of commercial products that work with, or complement, SQL Server Integration Services. In Extending Integration Services with the Script Task and Script Task Plus , Ivan Peev of CozyRoc...

Filed under: articles, vendors, portal, msdn