Category Archives: Uncategorized

You Can’t Get There From Here

Yes Yukon![1] I’ve had several people ask me about this offline in the last few weeks: Why can’t I connect to SQL server 2008 from Visual Studio 2008? My answer, of course, has been “because it doesn’t work in the … Continue reading

Posted in Uncategorized | Leave a comment

Words of Wisdom from Donald Farmer

My favorite SSIS quote of the day: “Rolling your own ETL is king of like rolling your own cigarette – if youroll it too tightly, you can’t get any throughput” — Donald Farmer

Posted in Uncategorized | Leave a comment

Katmai for the BI Guy

I attended a session yesterday here at TechEd 2007 in Orlando – DAT 201, SQL Server 2008 “Katmai” Overview with SQL Server General Manager David Campbel presenting. Although there was very little detail information, it was quite a good session, … Continue reading

Posted in Uncategorized | Leave a comment

SQL Server 2008… Katmai No More…

So here I am in Orlando, feeling old. For years we’ve been calling it “Katmai,” but now…    …Mike Woods did a demo talking about service enablement for applications. A big part of the demo was BizTalk 2006 R2 orchestrations (yes, … Continue reading

Posted in Uncategorized | 1 Comment

Having trouble getting a Date?

There have been several questions posted lately on the MSDN SSIS Forums asking how to convert integer or string date values into “real” DATETIME values in an SSIS package. I figured that this would already be over-documented online, but as … Continue reading

Posted in Uncategorized | 8 Comments

Watching Yellow Boxes Sucks

Here’s a chance for the world to learn from my stupidity. Like that will be the first [1] time, eh? Here I am, 9:35 PM, 2 hours past my regular bedtime. [2] 582,000 records processed so far. it’s been 3 … Continue reading

Posted in Uncategorized | Leave a comment

Comparing Database Versions

This post was inspired by a recent thread on the MSDN SSIS Forums. Here’s the scenario: Let’s say that you have a source database and a destination database. Let’s take this one step further and say that you have multiple … Continue reading

Posted in Uncategorized | Leave a comment