Using Data Transformation Services, part 3: Using the DTS Designer Objects (continued) - Add a workflow item to rectify the package
(Page 9 of 9 )
Highlight the HelloDTS ActiveX Script task and the FirstCopy connection, and add an On Completion Workflow as shown in this picture. This workflow specifies that, upon completing the HelloDTS task, the next Data Transformation task must be initiated.
Verify again after adding the workflow Case 1: Both Destin.txt and Destin2.txt exist but are empty. Upon executing this package with the work flow added, the result is as shown. The Transform Data Task is now waiting, and when the message box is relieved, the transformation is completed as shown in the next picture.
Case 2: Destin.txt does not exist; Destin2.txt exists, but is empty.
The package is successfully executed without any error in any of the steps, similar to case 1 above.
Destin.txt file output:
Destin2.txt file output:
Summary The DTS designer is mostly wizard driven and easy to work with. Several new items in the Data Transformation Services designer were described. The TextFile (Source) and TextFile (Destination) and their usage was described. The ActiveX Scripting task was described with the help of a simple script to copy a text file from one location to another. Data Transformation in the context of text files was described again with a simple example. Adding workflow helps in a situation where a step has to be completed before the next is initiated, as shown in this tutorial.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
