Hi. I am attempting to import a DB that was sent to me in CSV format. The
DB contains roughly 18,000,000 records. Unfortunately, on record 645,323 I
get an error that one of the delimiters is missing. The import fails.

Is there any way to bypass this? And any following errors? 1, 2, even 1000
records don't mean much in my application.

The CSV file is over 10GB. I haven't been able to find a text editor that
would allow me to actually inspect the records.

Thanks for the help.

Hi,

you can create a DTS package for import. Then you can try setting option Max
Error count to higher number. Default is 0 so task fails on the first error.
You can find this option in transformation task property under Options tab.

--
Danijel Novak
MCP+I, MCSA, MCSE, MCDBA, MCT


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