O'Reilly logo

SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy

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

Hands-On Exercise: Splitting Data Retrieved from a SQL Server

In order to follow the steps as indicated, you will need a data flow task that connects to a data source, and destinations to which the separated flows can be directed into, which includes a destination for the default flow that does not meet the criteria established for data splitting. You will also need to add and configure an in-memory ADO recordset destination, the Recordset Destination component to visualize the data.

The following are the major steps of this exercise:

  • Create a BI Project and add a Data Flow Task. Add and configure the DataReader Source to pull data from the Local SQL Server.

  • Add a Conditional Split Transformation.

  • Establish a path to Connect DataReader Source ...

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