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!

January 2009 - Posts

• SSIS Expression Language and Variables

  Introduction This post is part of a series titled An Introduction to the SSIS Expression Language . In this post, I demonstrate the SSIS Expression Language and Variables. To build the demo project described in this article you will need SSIS 2005 and Read More... Posted Saturday, January 31, 2009 12:02 AM by andyleonard | 12 Comments Filed under: Expression Language, SSIS

• An Introduction to the SSIS Expression Language

  The SSIS Expression Language is one of the steeper slopes on the SSIS learning curve. Many database professionals have never been exposed to the syntax. In this series, I provide examples that demonstrate common uses for the SSIS Expression Language. Read More... Posted Friday, January 30, 2009 12:01 AM by andyleonard | 9 Comments Filed under: Expression Language, SSIS

• Presenting at New England SQL Server User Group!

  I am getting psyched about presenting to the New England SQL Server User Group in a couple weeks! On 12 Feb I'll be talking about Incremental Loads, Change Data Capture, and SSIS 2008. The bonus is I get to hang out with my friend Adam Machanic ! If you Read More... Posted Wednesday, January 28, 2009 11:35 PM by andyleonard | 1 Comments Filed under: Developer Community, ETL, Incremental, SQL Server 2008, SSIS, User Groups