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.