Row Transformations
Row transformations are simple compared to other types of transformations. As we did with the control flow, the order of the transformations will be changed to suit your learning requirements. Starting with the simplest transformation—i.e., Copy Column transformation—to copy an input column to output columns, we will study the Character Map transformation, Data Conversion transformation, and then the Data Derivation transformation. The ability to perform more complex functions will increase as we go till we reach the last two transformations, Script Component and OLE DB Command, in this category, which can be programmed to perform precisely the functions you want. Let’s start our journey with Copy Column transformation.
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.
