Focal Point
Finding sqlin temp file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/7101098331

August 16, 2005, 05:57 PM
Steve C
Finding sqlin temp file
I would like to capture the SQLIN file created during the ETL process by data migrator. Doing a filedef in EDASPROF does not work, any other suggestions?

Steve
August 17, 2005, 02:19 PM
<DocServices>
Hi Steve,

I received this information from a project manager regarding your question:

The SQLIN is not a real file. The output from the select statement (SQLIN) becomes the input to a modify, without ever getting written to disk as a file. If you want an intermediate flat file, you could always disable automatic pass through, slowing things down a bit.

Hope this helps.

Regards,
Jennifer