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

(Page 1 of 5 )

This tutorial builds on earlier articles in the series, which explained (among other things) how to create a DTS package with ImportExportWizard. In this article, you will learn how to execute the DTS packages designed and saved on the SQL Server from ASP.NET using Visual Studio 2003.

In previous tutorials, step-by-step methods of creating a DTS package with ImportExportWizard, as well as using the DTS Designer, have been described in considerable detail. The scripting involved in data transformations was also described.

The main focus of this tutorial is to guide the user in executing the DTS packages designed and saved on the SQL Server from ASP.NET using Visual Studio 2003. In order to complete the tasks in this tutorial, the reader is advised to review the previous tutorials on this topic available online.

We will follow the steps indicated here:

Part A:

• Create a dts package
• Create an SQL Connection
• Create an MS Excel Connection
• Create a Transform Data Task
  This task populates a table in SQL server with data in an excel worksheet
• Configure the task
• Save the package and execute
• Verify the results of transformation

Part B:

• Create a Web project using VS 2003
• Add references to DTS COM Assemblies
• Write simple code to execute the package
• Verify the results

Part A:

We will completely skip this part, except for showing some of the important specifics that are needed in executing the package via ASP.NET using the VS 2003 IDE. Please refer to the earlier tutorials located here for details.

Next: Creating the package details of the two connections >>
 

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!