Monthly Archives: May 2007

Going to TechEd!

Microsoft’s biggest technical conference – TechEd – is taking place next week in Orlando, and I’ll be there. This will be the first conference I’ve attended since TechEd 1998 in Orlando, when SQL Server 7.0 was the “next big thing.” … Continue reading

Posted in BI, Conference | Leave a comment

No! No! No!! Not the PDC!!!

It looks like the Professional Developers Conference this year has been cancelled, or at least indefinitely postponed: We are currently in the process of rescheduling this fall’s ProfessionalDeveloper Conference. As the PDC is the definitive developer event focused onthe … Continue reading

Posted in Conference, dev | 1 Comment

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

Dr. Ivan Brady Strikes Again!

If you’ve ever gotten an email from me, odds are it’s had this as the signature: “Context is practically everything when it comes to determining meaning”— Dr. Ivan Brady Dr. Ivan Brady was my favorite professor when I was in … Continue reading

Posted in Quote | 1 Comment

Conditional Task Execution

As we saw in the last post, the combination of SSIS Expressions, variables and precedence constraints gives us a lot of power for determining what execution path our package should take. But what happens if the logic we need to … Continue reading

Posted in BI, SSIS | 6 Comments

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

Flexible File System Deployment

This blog post has been sitting in my drafts folder since the day I created this blog, and has been kicking around in my mind for much, much longer. The real world just keeps getting in the way of my … Continue reading

Posted in BI, SSIS | 2 Comments