Error testing transformations in SQL7 DTS package

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]

Do you have enough hard drive space? I think the entire transformation must fit.

------------
William Brown at 3/8/01 5:12:27 PM


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]

Gigas of disk space are available. And remember, the task actually executes, it just the transformations that won't test.


------------
James May at 3/8/01 6:03:59 PM

Do you have enough hard drive space? I think the entire transformation must fit.

------------
William Brown at 3/8/01 5:12:27 PM


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]

I can pretty much garuntee that if it is a temporary file it is retrievable somehow. Sorry, I'm somewhat new to SQL admin and don't know where it is but you may want to do a search on *temp*. and check the temp directory of your operating system


------------
William Brown at 3/8/01 5:12:27 PM


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]