View Data

DTS Designer

DTS Designer Help

View Data

Use this dialog box to inspect source data that will be used by a transformation task, or to review the results of a test run of a transformation.

When used after testing a transformation, the View Data dialog box allows you to view the temporary text file containing the transformation results. You can check the data to ensure that the transformation is producing the expected results.

Because test mode sends data to a file rather than the actual destination, problems with the provider, the destination, or data type overflow may not be detected. Therefore, in certain cases, test results may not accurately represent the performance of a transformation task.