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.
1. Create a business intelligence project Ch 4 as described in Chapter 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. 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, ...