Speed of DTS step which creates flat file on remote machine -
03-14-2005
, 05:29 PM
I inherited a package which creates a flat-file on a remote pc ( ex.
\\remotepc\dir1\file.txt). When the output file appears in the remote
directory, it grows very slowly. The sql which is the DTS data source is a
normal sql statement with a Group By. I take this to mean that the entire
set of data is retrieved and grouped before the file starts writing. Is this
true? Would it be faster to create the file "locally" and then copy the file
to the remote machine?
Michael |