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 Access Database

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.

  • Incorporating ...

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