Testing Transformation

DTS Designer

DTS Designer Help

Testing Transformation

Use this dialog box to view the execution progress of the Microsoft® ActiveX® script transformation you selected.

The transformation is run on the source data, and the results are copied to a temporary text file. The destination table is not affected. Because test mode sends data to a file rather than the actual destination, problems with the provider, the destination, or the data type overflow may not be detected.

Options

Execution Progress

View the progress of the transformation being tested.

Execution status

View error information about a transformation that did not execute correctly. Double-click the step.

Done

Display the ActiveX Script Transformation Properties dialog box, where you can change the ActiveX script.

View Results

Display the View Data dialog box, where you can view the contents of the temporary file containing the results of the test transformation.

See Also

Using ActiveX Scripts in DTS

Tasks That Transform Data

Transform Data Task