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...

SQL Server 2008 R2 was released to manufacturing today! For more R2 information, please see: SQL Server 2008 R2 Website SQL Server 2008 R2 Digital Tour SQL Server Team Blog SQL Server Performance Blog R2 was really focused on self-service business intelligence...

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...

They’ve posted 10 minute previews for some of the talks at the upcoming SSWUG.ORG Virtual Conference . Here are some of the SSIS related topics: Matt Masson - Incremental Data Warehouse Loads with Merge & CDC John Welch -  Doing More (ETL) With...

SQL Server 2008 SP1 is now available for download, as well as the updated Feature Pack . Happy downloading!

I flew to Tucson last week to record my sessions for the upcoming SSWUG.ORG Spring Virtual Conference . I recorded three sessions for the BI track : How to Avoid Common Pitfalls with SSIS Starting up a new project with SQL Server Integration Services...

Xiaochen Wu, a member of our Shanghai team, has started a Chinese SSIS blog . He’s started it off by translating some of the posts I’ve done, and I’m sure he’ll find plenty of content in the future. I don’t know what the following text means, but I assume...