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 an Excel File

This exercise consists of the following major steps:

  • Creating a BI project and adding a Data Flow Task.

  • Configuring the DataReader's Connection Manager.

  • Configuring the DataReader Source.

  • Adding a Character Map Transformation.

  • Adding an Excel Destination and establishing a path to it from the Character Map Data Flow Component.

  • Configuring the Excel Destination Component.

  • Testing the package.

In order to follow the steps as indicated, you will need a source and a destination: the source data is extracted from the MyNorthwind database (just a renamed version of the Northwind database) on the SQL Server 2005 Server, and the destination is loading this to an MS Excel 2003 spreadsheet file on your ...

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