Dougbert on SSIS

Making SSIS work with the 64-bit Excel (ACE) provider

dougbert — Wed, 01 Sep 2010 18:50:00 GMT

I've previously blogged about the challenges of the new 64-bit ACE Provider that includes the Excel driver, since the 32-bit and 64-bit versions cannot be installed side-by-side. In this detailed post that includes screen shots, Hrvoje Piasevoli from...(read more)

Restarting SSIS packages after failure

dougbert — Mon, 23 Aug 2010 20:52:00 GMT

Last week while I was on vacation, my Microsoft colleague Steve Howard posted another detailed article on an aspect of SSIS that's frequently misunderstood - restarting SSIS packages after a failure . Steve is often asked to explain and demonstrate...(read more)

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)

Loading Active Directory data with SSIS

dougbert — Tue, 10 Aug 2010 14:03:00 GMT

Steve Howard - the same guy who previously provided detailed clustering advice on this blog - has posted an article that includes 3 different approaches for retrieving Active Directory information in an SSIS package. The article includes screen shots...(read more)

How to follow a German SSIS blog in English

dougbert — Mon, 09 Aug 2010 01:01:00 GMT

Did you know that there's an active SSIS blog in German by Tillman Eitelberg from Bonn in Germany? You can read it in [imperfect] English by using the Microsoft translator in your browser. First, here's the blog: http://ssis-components.net/ The...(read more)

New ETL framework (beta of version 1.0) released on Codeplex

dougbert — Mon, 09 Aug 2010 00:49:00 GMT

SSIS consultant and blogger James Beresford ("BI Monkey") of Sydney, Australia has released the beta of version 1.0 of an ETL Framework on Codeplex, described as " an ETL Execution, Control and Logging system for ETL projects using SSIS...(read more)

Using SSIS to republish SSRS reports in bulk

dougbert — Sat, 26 Jun 2010 14:35:00 GMT

MSDN has recently published an article that explains how to update parameterized SQL Server Reporting Services (SSRS) reports in bulk by using a SQL Server Integration Services (SSIS) package. The article, Bulk Report Generation using SSIS and SSRS 2008...(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)

Top Connect issues recently for SSIS

dougbert — Fri, 11 Jun 2010 21:47:00 GMT

This afternoon I was testing to see whether I had VSTS installed correctly, and I clicked on one of my saved queries for Microsoft Connect items related to Integration Services. Whoa! People are NOT happy about the incompatibility with Visual Studio 2010...(read more)

Wow, an SSIS Expression Tester tool

dougbert — Thu, 10 Jun 2010 20:28:00 GMT

Darren Green of SQLIS .com has posted a new SSIS Expression Tester on Codeplex: http://expressioneditor.codeplex.com/ See the SQLIS blog post from yesterday (6/9/10): http://www.sqlis.com/sqlis/post/ssis-expression-editor-tool.aspx German-language blog...(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)

SSIS and spatial: A new article and some existing custom components

dougbert — Wed, 07 Apr 2010 20:58:00 GMT

New 3-part walkthrough Today (April 7, 2010), sql-server-performance.com published the 1st of a 3-part series of articles by BI blogger Siddarth Mehta , titled " Geocoding Text-Based Spatial Data for Use In SSIS Packages ." The sample project...(read more)