Flat file import skipping records

#1

Hi, I'm new to sql,

Importing a large flat file (positional text) into MSSQL using DTS, records
are occassionally skipped. On two spot checks I found records present in the
input file but missing in MSSQL. No errors were generated during import.

Please help
Thanks
--
chris
ckloss (AT) mcsystems (DOT) net

#2

Have you checked the data file extra commas or single quotes. This
sometimes causes problems with the imports.

Rick

"chris kloss" <ckloss@mcsystemsPERIODnet> wrote

Quote:

Hi, I'm new to sql,

Importing a large flat file (positional text) into MSSQL using DTS,
records
are occassionally skipped. On two spot checks I found records present in
the
input file but missing in MSSQL. No errors were generated during import.

Please help
Thanks
--
chris
ckloss (AT) mcsystems (DOT) net

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Flat file import skipping records

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Flat file import skipping records - 08-04-2005 , 11:16 AM

Re: Flat file import skipping records - 08-04-2005 , 12:20 PM