Data Flow Transformations
Once the data has been captured by source adapters and passed on to data flow path, you can modify this data using a vide range of data flow transformations provided in SSIS. You can use data flow transformations to aggregate column values, update column values, add columns to the data flow, merge data, and many perform more to apply data modifications. The Output columns of the data flow source provide data to the Input columns of the data flow transformation. Data flow transformations can have single or multiple inputs or outputs depending upon the type of transformation you choose. After applying transformations on to the data, the data flow transformation provides the output through its output columns to the input ...
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.
