My friend Steve Fibich has published a small series on examining DTExec processes to determine which SSIS packages they're running. He uses WMI and PowerShell. Really cool stuff - check them out! dtexec.exe what are you doing? dtexec.exe what are you doing? (part II) :{> Andy

My latest SSIS 101 article - SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers - is live at SQL Server Central today! Enjoy! :{> Andy

I haven't fallen off the planet, I am still alive and kicking! I've been on the road the past couple weeks - first in Kansas City, MO and this week in Bellevue, WA. I got to meet a bunch of cool people at the classes in Kansas City and Bellevue, and at the Kansas City SQL Server Users Group. I've been working on this, which will be ...

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

On the MVP Summit...  Later today Christy and I leave Seattle. Our trek to my first MVP Summit was our first trip alone since Stevie Ray was born - and Stevie Ray turned five in February. We won't wait that long again. We had fun! :) Since this was my first MVP Summit I'm not sure how it compares with previous years. ...

I've started a community website for ETL and SSIS: AndyETL.com. My hope is the site will become an additional repository for ETL and SSIS information. :{> 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 metrics ...

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 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 will expand on our database and the SSIS package to annotate version metadata, manage error ...

Introduction   SSIS is a fantastic ETL engine. When I build an ETL solution in SSIS, I like to collect runtime metrics. Why? I use the data initially to determine a baseline for performance and to determine, in some cases, if I'm loading within a defined window.   I refer to this process of collecting ...