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