Author:Andy Leonard

I am regularly asked about passing variable values between SSIS packages. Tim Mitchell (Blog | @Tim_Mitchell) wrote an excellent Notes from the Field article for the SQL Authority blog called SSIS Parameters in Parent-Child ETL Architectures. Before the first version of the SSIS Catalog was even released, Jamie Thomson blogged about The new Execute Package …
Continue reading SSIS Design Pattern: Access Parent Variables from a Child Package in the SSIS Catalog

Not once, in my combined years of direct employment by enterprises or consulting, has a customer contacted me about an issue about the grain of their date dimension in their enterprise data warehouse. Not one single time. I haven’t been contacted about cardinality either. Or trouble with execution threading models. Nope. Not ever. Instead, I’ve …
Continue reading What Customers Want

I love learning new stuff! I’m blessed to work with a talented group of individuals at Linchpin People. We often work together in teams and I have to admit, I cherish those times. One reason is I learn something new. Every. single. time. For years, I’ve validated SSIS Script Task code by searching for red …
Continue reading Validate SSIS Scripts Before Closing the VSTA Window

Own the SSIS Design Patterns (2nd edition – updated for SSIS 2014) ebook today for just $10! :{> Learn more:  Stairway to Biml Linchpin People Blog: SSIS Stairway to Integration Services

I am honored to present Using Biml as an SSIS Design Patterns Engine at the Hampton Roads .Net Users Group (@HRNUG) 11 Aug 2015! Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of Biml in …
Continue reading Presenting Using Biml as an SSIS Design Patterns Engine at Hampton Roads .Net UG 11 Aug

I’ve received a couple inquiries recently about SSIS training for people new (or new-ish) to data integration. I have delivered a course called From Zero To SSIS in the past, but not recently. If you are interested in this training, please contact me by clicking the Email link in the upper right frame. If enough …
Continue reading Interested in Training – From Zero To SSIS?

… to some folks more than others. We likely all have stories about working with folks who care a lot about the format of their SQL statements. I’ve worked with a lot of database developers and analysts. I cannot say SQL formatting distinguishes the good from the bad (or ugly), but I have noticed the …
Continue reading SQL Formatting Matters…

Extending Custom Execution in the SSIS Catalog – Level 21 of the Stairway to Integration Services is now live at SQL Server Central! Enjoy! :{> Learn more:  Stairway to Biml Linchpin People Blog: SSIS Stairway to Integration Services

I’m honored to present two sessions Friday 10 Jul 2015 at CodeStock 2015! At 10:15 AM, right after the keynote by THE Scott Hanselman, I’m presenting Designing an SSIS Framework. At 2:40, I’m presenting SSIS 2014 Data Flow Tuning Tips and Tricks. I hope to see you there! :{> Learn more:  Stairway to Biml Linchpin …
Continue reading Presenting at CodeStock 2015!

I’m honored to present “SSIS Data Flow Performance Patterns” at the Charlotte BI Group 7 Jul 2015! In this session, I discuss Data Flow Task internals and patterns that improve SSIS 2014 Data Flow performance in your data integration enterprise: Incremental Loads, Blob Pyramid, and Type 2 New + Updated Rows. Plus, I tell funny …
Continue reading Presenting SSIS Data Flow Performance Patterns at Charlotte BI Group 7 Jul!