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 ...

I like SourceGear. I like what I know about the company, the people, and their products - mostly the people. SourceGear DiffMerge is helping me this morning. I created an FTP class  in an SSIS Script Task from code I found online because... well, that's another post. At this point in my refactoring, I have implemented ...

You can find SSIS 2005 Custom Tasks and Component Samples at CodePlex. At the same location you can find SSIS 2008 samples. How cool is that? The samples include source code in VB.Net and C#. They serve as a decent starting place for developing your own SSIS custom tasks and components. Free registration to CodePlex is required to access the ...