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

I'd like to thank the people that attended my sessions at the 2007 PASS Summit in Denver this week! I had a blast and hope you all did as well. The code will be available from the PASS website and on a DVD. For those in my sessions, I promised I would post the code here for my custom Counts test condition for Team Edition for Database ...