....non-whitespace characters were found after the last defined column's data.

Here I was attempting to import a text file where each record is 730 bytes
and has 49 fixed-length columns.

Are there restrictions to how many records and how wide the records can be
imported in a DTS package? If so, where can I find documentation about
this?

Thanks,

The restrictions are on the destination's limits

What you have is not unreasonable.

What it is telling you is that your file does not look like it should. To
the eye it looks clean. Look at it in a HEX editor and it should appear
differently.

This issue is seen a lot.



--



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


"InformataDBA" <InformataDBA (AT) discussions (DOT) microsoft.com> wrote