Introduction I built a SQL Server 2008 Maintenance Plan and included a Maintenance Cleanup Task. For those who don't work with this stuff every day, Maintenance Plans are actually SSIS packages. The short version of a long story is: I couldn't execute the Maintenance Plan on the server. I won't go into that (not now, at least); but I noticed a ...

Jamie Thomson has posted a great series on the SSIS 2008 Data Profiling Task. The Data Profiling Task allows developers to quickly assess key statistics about data in a database table. When I say ''statistics'' I mean things like column value and length distribution, column null ratio, column patterns, and functional dependencies. You ...