Export (0) Print
Expand All
Expand Minimize

Testing Transformation

SQL Server 2000

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.


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.


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

© 2014 Microsoft