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