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: Transferring Data to a Text File

In order to follow the steps as indicated, you will need a source and a destination; the source data will be coming from SQL Server 2005, and the destination would be writing this to a flat file on your hard drive. You also need to establish a path connecting them.

Step 1: Creating a BI Project and Adding a Data Flow Task

  1. 1. Create a business intelligence project Ch 4 as described in Chapter 2.

  2. 2. Change the default name of the package to TableToText.dtsx. Drag and drop a Data Flow Task from the Toolbox on to the Control Flow page.

  3. 3. Click the Data Flow tab that displays the Data Flow page.

    Now, you will be able to access the Data Flow items of the Toolbox, consisting of Data Flow Sources, ...

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