T-SQL Tuesday: Aggregations in SSIS

Posted by andyleonard on SQL Blog See other posts from SQL Blog or by andyleonard
Published on Tue, 08 Mar 2011 19:00:00 GMT Indexed on 2011/03/09 0:16 UTC
Read the original article Hit count: 310

Filed under:
|
|
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 Transformation in SSIS The Aggregate transform in SSIS is fast . I built an SSIS package (AggregateScripts.dtsx) with two Data Flow Tasks (Using the Aggregate Transform and Using a Script Component). Using the Aggregate Transform looks like this:...(read more)

© SQL Blog or respective owner

Related posts about etl

Related posts about ssis