O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required