Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!

Browse by Tags

All Tags » ETL » SSIS   (RSS)

• Business Intelligence
• Code Camp
• Data Warehousing
• Database Developer
• Design Pattern
• Developer Community
• Elegant Design
• ETL Instrumentation
• I-Am-Such-A-Geek
• Incremental
• measurement
• Mentoring
• Microsoft
• Presentations
• SQL Saturday
• SQL Server
• SQL Server 2008
• SQL Server 2012
• SQLLunch
• SQLRally
• SSIS 2012
• SSIS Frameworks
• Stairway to SSIS
• Support
• T-SQL Tuesday
• User Groups

• Little Data Remains Important in Healthcare IT

  In his article Healthcare's Big Problem With Little Data , author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization Read More... Posted Tuesday, April 30, 2013 11:31 AM by andyleonard | 2 Comments Filed under: SSIS, ETL, ETL Instrumentation, Elegant Design, Presentations, Data Warehousing, SSIS 2012

• Have You Downloaded SQL Server 2012 Evaluation Edition? Why Not?!

  I am installing SQL Server 2012 Evaluation Edition on a virtual machine as I type. You can do this. Here’s one way: Grab some virtual machine software. I like Oracle VirtualBox . It’s cool. It’s free. Install VirtualBox. Download the 180-day free trial Read More... Posted Thursday, March 08, 2012 3:00 PM by andyleonard | 8 Comments Filed under: SSIS, ETL, Business Intelligence, SQL Server 2012

• Updated SSIS Framework, Now Includes Reports

  I have built a beta version of Linchpin People ’s SSIS Framework, now including much-requested reports. You can grab the updated copy here . I appreciate any feedback you care to share. :{> Read More... Posted Wednesday, March 07, 2012 8:00 AM by andyleonard | 5 Comments Filed under: Design Pattern, SSIS, ETL, Presentations, SSIS Frameworks

• Stairway to SSIS Step 3–Adding Rows in Incremental Loads

  If you haven’t yet, check out the Stairways – a series of tutorial articles at SQL Server Central. They. rock. I was really excited when Steve Jones ( Blog | @way0utwest | SQLPeople ) contacted me to write the Stairway series of tutorials for SSIS! The Read More... Posted Friday, September 16, 2011 8:00 AM by andyleonard | 0 Comments Filed under: SSIS, ETL, Stairway to SSIS

• Designing an SSIS Framework

  In preparation for SQL Saturday #84 – Kalamazoo , SQLBits 9 , and the PASS Summit 2011 ; I’ve been honing my presentation called Designing an SSIS Framework. I delivered this presentation a few times over the past couple months. Each time, I promised Read More... Posted Friday, September 16, 2011 8:00 AM by andyleonard | 20 Comments Filed under: Design Pattern, SSIS, ETL, Presentations, SSIS Frameworks

• Presenting at SQL Saturday #84–Kalamazoo 17 Sep 2011!

  Introduction I am honored to present Designing an SSIS Framework and “I See a Control Flow. Now What?” at SQL Saturday #84 in Kalamazoo Michigan 17 Sep 2011! I See a Control Flow. Now What? This highly-interactive, demo-intense presentation is for beginners Read More... Posted Wednesday, September 07, 2011 6:00 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, ETL, SQL Saturday, Presentations

• I Am Here To Help™

  Introduction This isn’t a trick. It’s not a gimmick. It’s not bait-and-switch. It is selfish; please allow me to explain: I Am Here To Help™ This has been my motto for the past few years. How can I serve you today? Are you thinking about starting a User Read More... Posted Friday, August 19, 2011 10:30 AM by andyleonard | 4 Comments Filed under: SSIS, Developer Community, SQL Server, ETL, Support, Mentoring

• Presenting at Hampton Roads SQL Server and SharePoint Users Group Tomorrow!

  I am honored to present Designing an SSIS Framework to Hampton Roads SQL Server and SharePoint Users Group tomorrow, 20 Jul 2011! You can register here . Details: Infotec 100 Constitution Dr Virginia Beach, VA 23462 Wednesday, July 20, 2011 at 6:30 PM Read More... Posted Tuesday, July 19, 2011 1:58 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, Developer Community, SQL Server, ETL, User Groups, Presentations

• Presenting at Regina Technology Community 26 Apr 2011!

  Introduction I'm honored to deliver two presentations to the Regina Technology Community 26 Apr 2011! Part I - Database Design for Developers This interactive session is for software developers tasked with database development. Attend and learn about Read More... Posted Tuesday, April 19, 2011 8:00 AM by andyleonard | 0 Comments Filed under: Incremental, SSIS, Database Developer, ETL, Presentations

• T-SQL Tuesday: Aggregations in SSIS

  Introduction Jes Borland ( Blog | @grrl_geek ) is hosting this month's T-SQL Tuesday - started by SQLBlog's own Adam Machanic ( Blog | @AdamMachanic ) - and it is about aggregation. I thought I'd show a couple ways to do aggregation using SSIS. The Aggregate Read More... Posted Tuesday, March 08, 2011 3:00 PM by andyleonard | 3 Comments Filed under: SSIS, ETL, T-SQL Tuesday

• Presenting at Roanoke Code Camp Saturday!

  Introduction I am honored to once again be selected to present at Roanoke Code Camp ! An Introductory Topic One of my presentations is titled "I See a Control Flow Tab. Now What?" It's a Level 100 talk for those wishing to learn how to build their very Read More... Posted Monday, March 07, 2011 1:00 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, Developer Community, ETL, Code Camp, Presentations

• A Day of SSIS in May

  Introduction I could run through the abstract for my submission to the SQLRally pre-con - and I will include much of it in this post. But Wait There's More! It's difficult to convey in writing my passion for SQL Server Integration Services. I like the Read More... Posted Monday, November 01, 2010 12:00 PM by andyleonard | 0 Comments Filed under: SSIS, ETL, SQLRally

• SQLRally Pre-Conference Voting Is Open!

  SQLRally The SQLRally team has been working overtime and you can now vote on the pre-conference session you'd most like to see. What a great idea. This is a much better way to select pre-cons . This way, the SQL Server Community wins. I submitted a pre-conference Read More... Posted Tuesday, October 26, 2010 1:00 PM by andyleonard | 0 Comments Filed under: SSIS, Developer Community, ETL, Business Intelligence, SQLRally

• Presenting at SQLLunch Today!

  I'm honored and excited to present SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns for SQLLunch today (11 Oct 2010)! In this talk, I cover building a custom logging solution in SSIS. I hope to see you there! :{> Read More... Posted Monday, October 11, 2010 8:00 AM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, ETL, SQLLunch

• Presenting SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns at SQLLunch Today!

  I am honored to present SSIS Design Patterns 1b: Incremental Loads and Parent-Child Patterns at SQLLunch today beginning at 12:30 PM EDT! This is part two of a three part series. (UPDATED) In this presentation, I walk through Incremental Load and Parent-Child Read More... Posted Monday, September 13, 2010 9:00 AM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, ETL, Business Intelligence, Presentations, SQLLunch