Hi,

The DTS transformation of a text data file onto a table always skips the
last record. But the last record seems to have the LF similar to the
other records.

Are there any reasons it might do so?

Thanks,
John Jayaseelan




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

The only reason I can think of and you already seem to be looking at this is
the line terminator on the previous row is oncorrect.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"John Jayaseelan" <john.jayaseelan (AT) caravan-club (DOT) co.uk> wrote