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 » T-SQL Tuesday   (RSS)

• ETL
• Expression Language
• SSIS

• 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

• T-SQL Tuesday #001: A Couple SSIS Date Expressions

  Adam Machanic is hosting this month's T-SQL Tuesday (the first!) on Date/Time Tricks . I thought I'd share a couple datetime SSIS Expressions I use regularly to format dates. First, I created an SSIS solution named ExpressionsTester, to which I added Read More... Posted Tuesday, December 08, 2009 12:26 PM by andyleonard | 0 Comments Filed under: SSIS, Expression Language, T-SQL Tuesday