BI Thoughts and Theories

I ran across a forum post today that highlighted a limitation with connection managers that I wasn't aware of, so I thought I'd post it here. If you have RetainSameConnection set to TRUE, and you are also trying to update the connection string through Read More...

I've been a bit lax posting on my blogs and the MSDN forums recently. Fortunately, I have a good reason (at least I think it's a good one). :) My employer, Mariner , has graciously given me permission to open source a unit testing framework for SSIS packages. Read More...

SQL Server 2008 introduces a new task that allows you to profile the data in a table. Jamie Thomson has a great series of posts about the different profiling options available on the task. If you are not already familiar with the task, I highly recommend Read More...