What is AggregateText SSIS component?

This component is used for aggregating mulitple rows of text columns inside an SSIS component. It allows you define keys, which act as a 'Group By' clause and concatenates rows in the data flow with identical keys.

Installation

copy AggregateText.dll "%ProgramFiles%\Microsoft SQL Server\100\DTS\PipelineComponents\"
gacutil /u AggregateText
gacutil.exe -iF "%ProgramFiles%\Microsoft Sql Server\100\DTS\PipelineComponents\AggregateText.dll"

If you do not have gacutil.exe, I think you can replace the last two steps with copying the .dll to C:\WINDOWS\assembly in Window explorer.

Configure Visual Studio

You should now see 'AggregateText' show up in the control flow items.

Use


That's really all there is to it. Please let me know if any of the documentation can be clarified. Also, how I can attach graphics. I have some screen shots that might be handy.