Rowset Transformations
The Rowset transformations work on record sets. These transformations first receive all the rows and then do the processing bit as the operations they perform need all the rows upfront. Among these are Aggregate transformation, Sort transformation, Percentage and Row Sampling transformations, and Pivot and Unpivot transformations. You will work through two Hands-On exercises built around these transformations—one built around the Aggregate transformation and the other one built around the Pivot transformation, in which you will also use Sort transformation along with other data flow components.
Sort Transformation
The Sort transformation allows you to sort input rows in ascending or descending order by selecting one or ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
