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; adding a Data Flow Task and configuring an Excel Source.

  • Adding a Data Conversion Data Flow Transformation.

  • Establishing a path from Excel Source to Data Conversion Data Flow Transformation.

  • Configuring the Data Conversion Data Flow Transformation.

  • Adding and configuring an OLE DB Data Destination.

  • Adding and Configuring a Recordset Destination for displaying errors.

  • Building the project and testing the package.

Step 1: Creating a BI Project; Adding a Data Flow Task and Configuring an Excel Source

Create a BI project Ch 10. Change the name of the default package to DCnvrt.dtsx. Drag and drop a Data Flow Task to the ...

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