Using Data Transformation Services, part 5: Package Execution with ASP.NET - Creating the package details of the two connections

(Page 2 of 5 )

There are two connections, one to SQL Server 2000 and the other to the Excel worksheet. All that is needed to set up a connection is to drag the connection control from connection collection and drop it in the designer.

The next two pictures show the two connections. The first one is the Source (Excel Worksheet), and the second is the Destination (SQL 2000 Server).

After adding a transform data task, it is configured as shown. Please refer to previous tutorials for the details. This picture shows the Source tab of the Transform Data Task.

The next picture shows the Destination tab of the Transform data Task.

The following picture shows the Transformations tab of the Transform Data Task. No fancy transformation is attempted here, as the main focus is executing the package with ASP.NET

The finished package is as shown in the following picture, saved under the name ExcelPack3. The package can be executed in several ways as discussed in earlier tutorials. One obvious way is to click on menu item Package in the editor, and click on Execute. This action would copy the the Excel spreadsheet to a table in a SQL 2000 Server database.

Next: Part B: Create a Web project >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Using Data Transformation Services, part 5: Package Execution with ASP.NET

>>> Be the FIRST to comment on this article!