Monthly Archives: March 2008

RetainSameConnection and Expressions

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 … Continue reading

Posted in Uncategorized | Comments Off on RetainSameConnection and Expressions

ssisUnit – A Unit Testing Tool for SSIS

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 … Continue reading

Posted in Uncategorized | Comments Off on ssisUnit – A Unit Testing Tool for SSIS

Using the Data Profiling Task To Profile All the Tables in a Database

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 … Continue reading

Posted in Uncategorized | Comments Off on Using the Data Profiling Task To Profile All the Tables in a Database