Hi,

I tried to import a CSV file (8M rows) into SQL2K (with
sp3), but the import stops after 2M rows with the strange
message above. Platform: Win2K sp3
I'm not sure, but it might be an issue with special
characters like ä etc. Any suggestion for this problem?

Thx,
Wilfred van Dijk

What is the rest of the error message?

You may be timing out
You may be running out of log space/disk space

Post the whole message please

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Wilfred van Dijk" <wfvdijk (AT) yahoo (DOT) com> wrote

Hi,

I tried to import a CSV file (8M rows) into SQL2K (with
sp3), but the import stops after 2M rows with the strange
message above. Platform: Win2K sp3
I'm not sure, but it might be an issue with special
characters like ä etc. Any suggestion for this problem?

Thx,
Wilfred van Dijk

The complete, and only message I got is:
General Error -2147008507 (8007405)

If I divide this file into smaller pieces, I get a "normal"
error like "Error at source for Row Number 1217001. Errors
encountered so far in this task: 2001"

It seems to be a problem with special characters.

OK

It would seem to suggest that your datafile has some bad data, badly
terminated data.

In 2000 you can log the errors to a log file (last Tab of the datapump)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


<anonymous (AT) discussions (DOT) microsoft.com> wrote