In SQL 7 DTS I'm creating a Data Driven Query Tasks. When I get to writing the transformations in VB Script and try using the Test button to test the script, I get the following message:



Error Source: Microsoft Data Transformation Services Flat File Rowset
Provider
Error opening datafile. The system cannot find the file specified.

The documentation says:

[The transformation is tested] by executing it against a part of the
source data and copying the results to a temporary text file, for
preview purposes.

I can find no place to specify what temporary file is used for the test result and, because it is temporary, have assumed the system creates and
deletes it as needed.

Is this true?

I get this test error for every transformation. even those that work correctly when the DTS package is actually executed.

What can I do to get the transformations to test properly?

Any help or hints will be greatly appreciated.



===============================

William J Brown
Systems Analyst
College of Human Medicine
A114 East Fee Hall
Michigan State University
East Lansing, MI 48824
Voice: (517) 432-7490
Fax: (517) 355-0342
Email: [email protected]