I finally get to meet Brian Kelley in person! I'll be presenting Incremental Loads, Change Data Capture, and SSIS 2008 to the Midlands PASS Chapter in Columbia, SC on Thursday 2 Oct 2008! If you're in the area and read this blog, stop by and say ''Hi''. :{> Andy

I will be presenting Change Data Capture, Incremental ETL, and SSIS 2008 to Philadelphia Code Camp 2008.2 Saturday, 17 May 2008! The good folks in Philadelphia always do a great job with Code Camps and the attendance numbers are growing to reflect that! They're sold out again. Great job! :{> Andy

Introduction  This post is part of a series of posts on ETL Instrumentation. In Part 1 we built a database to hold collected SSIS run time metrics and an SSIS package to deomnstrate how and why we would load metrics into the database. In Part 2 we expanded on our database and the SSIS package to annotate version metadata, manage error ...

Introduction   Loading data from a data source to SQL Server is a common task. It's used in Data Warehousing, but increasingly data is being staged in SQL Server for non-Business-Intelligence purposes.   Maintaining data integrity is key when loading data into any database. A common way of accomplishing this is to ...