I am trying to import a fixed length field text file using the transform data
task. When I run the step not all of the records get imported. I get no error
messages or warnings.
I can import the same file into both Access and Excel and get all records.

Any ideas as to why this would be happening?

Which rows are missing?

Is it possible that the rows that are being missed are not terminated correctly? (Have a look in a hex editor)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


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