Welcome to MSDN Blogs Sign in | Join | Help

March 2009 - Posts

Monday, March 30, 2009 9:58 AM

SSWUG.ORG Ultimate Virtual Conference – April 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?
Posted by mmasson | 1 Comments
Filed under:
Tuesday, March 10, 2009 9:26 AM

SSIS Team Blog – Now in Chinese

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
Posted by mmasson | 0 Comments
Filed under:
Tuesday, March 03, 2009 5:16 PM

We Loaded 1TB in 30 Minutes with SSIS, and So Can You

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
Posted by mmasson | 0 Comments
Filed under:
Monday, March 02, 2009 3:14 PM

API Sample – Programmatically create and export configuration files for your packages

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.SetExport().
Posted by mmasson | 1 Comments
Filed under:
Monday, March 02, 2009 3:09 PM

API Sample - Programmatically add a configuration file to a package

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 creates a package
Posted by mmasson | 2 Comments
Filed under:
Monday, March 02, 2009 11:32 AM

Microsoft Tech-Ed North America 2009

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
Posted by mmasson | 0 Comments
Filed under:
Monday, March 02, 2009 10:45 AM

How do I do UPDATE and DELETE if I don’t have an OLEDB provider?

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
Posted by mmasson | 0 Comments
Filed under:
 
Page view tracker