Adding Transformations to the Data Flow
Using your data map, you'll want to use one or more of the supplied data transformations in your package. Figure 7–19 shows the possible options.
Figure 7–19. SSIS has a large array of Data Flow Transformation components to select from.
To enhance your basic package, add two transformations to the data flow: Derived Column and Sort. Continue by removing the data flow path (green line) between OLE DB Source and OLE DB Destination. Click your OLE DB Source, and drag the green data flow path (success path) to the Derived Column transformation.
Configure the Derived Column transformation by right-clicking ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.
