Using Data Transformation Services: Using Global Variables with the DTS Designer - Execution

(Page 3 of 5 )

This package is now ready and can be executed. The package execution step is shown in the next two pictures. The first one shows how to execute the step and the second shows the progress bar of the execution process, as well as completion of the process.

 

The result of the execution is seen by bringing up the table in the Enterprise Manager, from which the orders were deleted. You will notice that the orders with order numbers 10250 and 10251 pertaining to the OrderDate 07/08/1996 have been deleted.

The next two pictures show the Event Log and the GlobalVal.txt after executing the package, items we created while configuring the package. Both of them provide similar information, and one of them persists to a file.

 

Next: Second Example: Update Records >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Using Data Transformation Services: Using Global Variables with the DTS Designer

· Most of the DTS tutorials on ASP free that I have written are related to using the...   >>> Post your comment now!