I learned a couple weeks back my proposal for a pre- or post-conference seminar entitled ''From Zero to SSIS'' had been selected as an alternate at the PASS Summit 2009. I was a little disappointed,  but then I looked at the incredible speakers and topics selected for pre- and post-conference seminars here.  These seminars ...

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