Monthly Archives: September 2007

Preparing A List of IDs for an IN Condition

There’s been a few questions on the MSDN Forums recently about using a list of keys in an IN condition in a WHERE clause. There are a few scenarios were this can be a bit tricky in SSIS, particularly if … Continue reading

Posted in Uncategorized | Comments Off on Preparing A List of IDs for an IN Condition

Changes Coming for SSIS 2008

At the PASS Summit this week, I heard a few interesting bits about SSIS 2008 that should be in the next CTP. One, ADO.NET will be fully supported, with a ADO.NET Data Source (renamed from the Data Reader Data Source) … Continue reading

Posted in Uncategorized | Comments Off on Changes Coming for SSIS 2008

Dynamically Pivoting Rows to Columns

Previously, I posted about dynamically un-pivoting columns to rows. In this post, we’ll look at the reverse scenario. Suppose that you have a list of sales orders, in this format: Sales Order Number Product SO-001 Hammer SO-001 Table Saw SO-001 … Continue reading

Posted in Uncategorized | Comments Off on Dynamically Pivoting Rows to Columns

Using the WMI Data Reader in SSIS

A recent post on the MSDN forums was asking about using the WMI Data Reader Task to retrieve information and send it to a SQL Server destination. I wasn’t very familiar with the task, so I decided to try it … Continue reading

Posted in Uncategorized | Comments Off on Using the WMI Data Reader in SSIS