In order to execute the steps as indicated, you will need a source and a destination; the source data is extracted from SQL Server 2005 and the destination is an MS Access Database table. You also need to establish a path connecting them. In addition, you will also incorporate a Data Viewer that will monitor the flow from the source to the destination.
The following are the major steps to be taken in this exercise:
Creating a BI project and adding a Data Flow Task.
Configuring the DataReader's Connection Manager.
Configuring the DataReader Source.
Adding an OLE DB Destination and establishing a path from the DataReader Component.
Configuring the OLE DB Destination Component.