I am trying to import a text file using DTS. The file is
not delimited by tabs or commas so I have to use fixed
length. When I scroll to the right of the preview screen,
I see that the end-of-line (red vertical line) is at the
end of the last character of the first line. But there are
other lines that are longer and they are truncated.

Any suggestions?

Thanks.

In message <6b7c01c3e688$50d198c0$a501280a (AT) phx (DOT) gbl>, dschrier13
<anonymous (AT) discussions (DOT) microsoft.com> writes
Dts does not like irregular line lengths, as this contrary to a valid
fixed length format. The only reliable way to handle this is to
pre-process the file and pad short lines to the maximum length.

There is a rather old, but still valid PaddingTask I wrote available
here-

Archive
(http://localhost/SQLDTSNet/default.aspx?273)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org