March, 2009

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

A popular SSIS talk at recent conferences has been about the ETL Record that we announced last year. They’ve converted the talk to a white paper, and it is now available on MSDN. It’s a very interesting read. Summary: In February 2008, Microsoft announced...

The previous sample shows how to add a reference to an existing configuration file. This sample shows how to create a new configuration file for a package. Things to note: The first step is to flag the property you want to export by calling DtsProperty...

Update 2009-03-03 : Darren Green has a post which covers the other configuration types as well . This sample programmatically adds a reference to an existing configuration file to a package. Things to note: The CreatePackage() method just...

Are you going to TechEd in May? I’ll be down there in lovely Los Angeles answering questions at the SSIS booth and doing a Chalk Talk on avoiding common pitfalls with SSIS. There’s only a couple of SSIS related breakout sessions this time around, but...

A comment on my post about writing to a MySQL database inspired me to put together this post about how to perform UPDATEs and DELETEs in an SSIS package. The common approach is to use the OLEDB Command transform to execute the SQL statement on a row by...