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 ...