I don't know of any quick fix for this, but one suggestion may be to do with
the line breaks used. What actually are they? Are they Cr+Lf or something
else. Maybe you need binary not ASCII transfer for example.
--
Darren Green
http://www.sqldts.com
"Srinivas" <cgseenu (AT) rediffmail (DOT) com> wrote
Quote:
Hi,
I have been trying to ftp a fixed format file using DTS (SQL Server 2000).
The file gets through, but the format of the file changes.
If i have 30 records on the original file,
The line break seems to disappear and the whole text appears in one line.
If FTP the file using command prompt and get command, the file is fine.
Any ideas why this happens ??
Thanks,
Srini |