Monthly Archives: May 2008

A Tip For TechEd

If you’re like me, you’re preparing for a trip to TechEd, Microsoft’s biggest technical conference, to spend a week or two at the Orange County Convention Center in Orlando, Florida. If this is the case, then I have an important … Continue reading

Posted in Conference, Tangents | 2 Comments

Checking SSIS Data Flow Metadata

The SSIS Data Flow is heavily dependent on metadata. In order for it to do anything meaningful, it needs to have access to the metadata for all of the sources and destinations with which it interacts – the column names … Continue reading

Posted in BI, SQL Server, SSIS | 1 Comment

Deploying and Testing Custom SSIS Components

SSIS provides two primary mechanisms for adding custom code to SSIS packages: You can use the Script Task (for control flow) or the Script Component (for data flow) to add .NET code directly to your package. You can develop your … Continue reading

Posted in BI, dev, Katmai, SQL Server, SSIS | 4 Comments

Checking the Value of a Variable in SSIS

It’s a pretty common debugging and diagnostic task to need to check the value of a variable. The SSIS designers in Visual Studio do provide a set of debugging tools, but sometimes it’s quicker and easier to get "low tech" … Continue reading

Posted in Beginners, BI, dev, SSIS | 5 Comments

The Danger of Thinking Grandly

There’s a great article today on The Register – my favorite UK IT news web site. I love The Register because they cover so many facets of the IT world that I don’t touch regularly myself[1], have a strong anti-Microsoft … Continue reading

Posted in Architect, Best Practices, dev | Leave a comment

SSIS on RunAs Radio

My interview on the online radio show "RunAs Radio" is now online – check it out here: This is a short (36 minutes, including the opening and closing bits) show where Richard Campbell, Greg Hughes and I talk about … Continue reading

Posted in Beginners, BI, Katmai, SQL Server, SSIS, Webcasts | Leave a comment

Another Reason to Avoid Data Sources in SSIS

I’ve often railed on the evils of Data Sources – the .ds files that you can add to your SSIS projects in Visual Studio. I tell people to avoid them whenever I’m talking about SSIS deployment, and I even gave … Continue reading

Posted in Best Practices, BI, Deployment, Katmai, SQL Server, SSIS | Leave a comment