Another talk at the MS BI Conference that I really found useful was Jeff Bernhardt’s talk about the different data integration technologies at Microsoft . Data Integration at Microsoft: Technologies and Solution Patterns There are many reasons to contemplate...

One of the sessions I did at the MS BI Conference last week is now available online at msteched.com . Beyond Scripting: Developing Reusable Extensions for Microsoft SQL Server Integration Services Have you written scripts for your ETL process that you...

While developing some custom transforms for my talks at the BI Conference next week , I hit a problem where I was getting an a failed HRESULT (COM Exception) in my PreExecute () method on a call to BufferManager.FindColumnByLineageID (). HRESULT 0xC020402D...

I’m happy to be presenting at SQL Saturday on June 12th. I’ll be presenting a modified version of the SSIS Performance Design Patterns I’ll be giving at the MS BI Conference in New Orleans next week. There seems to be a whole SSIS track at SQL Saturday...

As I previously mentioned , SQL 2008 R2 added new Bulk Insert functionality to the ADO.NET Destination. This changed the component version, which means that if you edit/save packages that have ADO.NET Destination components in R2, the package will give...

UPDATE 2013-03-25 : To clarify, VS2010 support was added in the SQL 2012 release. We also support VS 2012 .
---
There was a very lively connect issue about SSIS’ lack of support for VS 2010. Jeff Bernhardt recently posted an official reply...

The Pacific Northwest SQL Server Users Group has invited me to come speak to them about SSIS next week (Wednesday, May 12th). I’ll be presenting a preview version of my Performance Design Patterns talk that I put together for the MS BI Conference in June...

I’m really looking forward to presenting at Tech·Ed again this year! As you probably already know, the Microsoft BI Conference is happening at the same time / place, which means the conference will have even more BI content than it usually does. I’m currently...

Douglas blogged about this a while back , but it’s come up a couple of times in the last little while, so I thought I’d repeat it here.
The Excel 2007 default output format for the SSIS Excel Destination is Excel Binary Format (.xlsb). If you’re creating...

A new version of the SSIS connectors for Oracle and Teradata is now available from the Microsoft download site . Changes Performance Improvements for Oracle and Teradata Components Optimize conversion functions in the Oracle and Teradata source and destination...

A quick post today – I received this question from a customer earlier today, and it took me a little while to figure it out. We have a number of packages that use a SQL Server logger. We want to turn logging off, but don’t want to modify all of our packages...

I had a great time at PASS last week, and had a chance to talk to a lot of different SSIS users. One of the big topics seemed to be Slowly Changing Dimensions – I had a number of people ask for various improvements to the current Slowly Changing...

Ok, so it turns my previous post about R2 wasn’t entirely correct.
SSIS does have one new feature which appears in the latest SQL Server 2008 R2 CTP . If you open up the ADO.NET Destination UI, you’ll notice a new “Use Bulk Insert when Possible” check...

I’m really looking forward to attending PASS next week! I’ll be presenting two separate talks this time around: Maximize Your SSIS Investment with Tuning Tricks and Tips Session Details Maximize the performance of your packages with this set of best practices...

Update 2009-11-12 : One minor feature change announced .
Have you been holding your breath waiting for Microsoft to announce the new SSIS features for SQL Server 2008 R2 ?
The answer is pretty simple – nothing new is being added for SSIS in R2....

I was just looking at the sessions for the SQL PASS 2009 Summit and was happy to see so many SSIS presentations on the list! Andy Leonard Applied SSIS Design Patterns Steve Simon SQL Server Integration Services and the modern financial institution Davide...

The method I describe in my post about handling COMExceptions during package generation works if you have control over the package generation code, but sometimes you’ll be using third party libraries, or debugging after the fact. Note, the error codes...

You’ll occasionally receive a COMException when you’re programmatically generating SSIS package – typically when dealing with Data Flow components. These COM Exceptions will provide you with an HRESULT (ErrorCode), and no additional information. System...

I’ll be presenting for the Vancouver BI PASS Chapter next Friday, July 10th, at the Microsoft Canada offices. I really enjoyed meeting the Pacific Northwest SQL Server User Group a couple of weeks ago, and I’m looking forward to sharing SSIS with my fellow...

A recent discussion with MVP Andy Leonard about a new property which showed up on the Script Task in SQL Server 2005 SP3 reminded me that I’ve been meaning to blog about how the script task and script component cache their precompiled code at runtime...

I’ll be speaking at the Pacific Northwest SQL Server User Group meeting next Wednesday, June 10th. I’ll be giving an updated version of the Avoiding Common Pitfalls in SSIS talk I gave at TechEd a couple of weeks ago. It will be my first time attending...

This post is coming a little late (these have already been announced here and here ), but incase you haven’t seen these before, I wanted to bring attention to four new performance related created by the SQLCAT and SSIS teams. They mostly focus on larger...

I’ve uploaded the slides for the Chalk Talk I gave at TechEd last week. I always appreciate feedback (good or bad), and I’ve gotten some great comments so far. If you attended the session (or just like the slides), feel free to comment below.

I’ve put together the samples I used in the Incremental Data Warehousing talk I did at the SSWUG.Org Virtual Conference. You can download them from my sky drive, here: The zip has a readme.txt file that should explain how to setup and run the samples...