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.

Image

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.