I am trying to import a text file to a table in SQL
Server. It looks normal at the beginning. After I
chose "Fixed Field" - File type: ANSI, Row Delimiter: {CR}
{LF}, then click Next, it became misAligned. I could not
continue import. I tried different Row Delimiter, none of
them working.

The file looks normal in notepad or word - each row ends
with a paragraph mark, although the length of each row
varies.

Any help will be appreciated!

So is the real problem here that you have variable length rows?
Does the connection setup work if you manufacture a source text file with
same widths?

In lieu of this then you can pad the rows to make them the same width by
using the padding task here

http://www.sqldts.com/default.aspx?273



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"shenshiji@hotmail.com" <anonymous@discussions.microsoft.com> wrote in
message news:230b101c45df8$531193f0$a501280a@phx.gbl...
[quoted text, click to view]