Dougbert on SSIS : third-party products

Running multiple SSIS Foreach Loops in parallel

dougbert — Wed, 11 Aug 2010 18:00:00 GMT

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...(read more)

Running PowerShell tasks from an SSIS task

dougbert — Wed, 11 Aug 2010 17:39:00 GMT

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...(read more)

SSIS with Dynamics CRM: Case study from a large bank

dougbert — Wed, 16 Jun 2010 16:46:00 GMT

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...(read more)

New Excel components out in beta from Cozyroc

dougbert — Tue, 08 Jun 2010 22:41:00 GMT

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...(read more)

Installing a new version of an SSIS custom component

dougbert — Tue, 18 May 2010 19:54:00 GMT

Recently a friend asked for help with the, uh, challenges of cleanly installing a new version or build of a custom component for SQL Server Integration Services (SSIS). Here are the steps: Close BIDS or Visual Studio. Uninstall the old version of the...(read more)

More SSIS and spatial, with an offer from SAFE Software

dougbert — Fri, 23 Apr 2010 20:26:00 GMT

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...(read more)

Updated component: Refresh SSRS reports directly from an SSIS package

dougbert — Mon, 09 Nov 2009 21:29:00 GMT

My German's a little rusty, but I still try to follow the German-language SSIS blog by Tillman Eitelberg of Bonn, Germany. In yesterday's posting , he talks about his Report Generator Task project on Codeplex (in English). Many of you have probably...(read more)

CDC for heterogeneous sources with SSIS, from Attunity and Microsoft

dougbert — Tue, 03 Nov 2009 18:20:00 GMT

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...(read more)

Updated product: SSIS+ 1.4 from Cozyroc - Visit CozyRoc at PASS

dougbert — Mon, 02 Nov 2009 01:17:00 GMT

Cozyroc is exhibiting at SQL PASS 2009 for the first time this year. From the Cozyroc Web site : CozyRoc will be exhibiting at the Premier Conference for SQL SERVER Professionals. Visit CozyRoc at booth #508 and say HI. Cozyroc has just released version...(read more)

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

dougbert — Wed, 23 Sep 2009 22:10:00 GMT

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...(read more)

Import EBCDIC in SSIS packages with updated Lysine 1.1

dougbert — Fri, 20 Feb 2009 14:40:00 GMT

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...(read more)

New product: Data Quality Manager from Australia

dougbert — Sun, 08 Jun 2008 21:49:00 GMT

Microsoft consultant David Lean from Australia sent us information about a new data quality product from down under named Data Quality Manager . There's a wealth of information about the product on the site. It uses, and integrates with, Integration...(read more)

New product: EBCDIC Source component from Amino Software

dougbert — Sun, 08 Jun 2008 19:16:00 GMT

Today Ben Harrell of Amino Software announced their new custom Source component, code-named "Lysine" , for importing mainframe EBCDIC data into the data flow of an Integration Services package. The component also includes an EBCDIC connection...(read more)