BCP Data Import - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

BCP Data Import

Author

Topic

padgettbrian
Starting Member

23 Posts

Posted - 2012-02-17 : 15:52:15

I'm trying to import a very large amount of data heres a copy of the import command I'm using and the error. What's really odd is the MDF file is 1.5 GB but there's only 498 records in the DB. Please help before I start gettin drunk at my desk

USE DATA
GO
BULK INSERT DEC2011
FROM 'd:\DEC2011.TXT'
WITH
(DATAFILETYPE ='char',
FIELDTERMINATOR = '|',
MAXERRORS = 1000000 )

ROWTERMINATOR = 'row_terminator')

Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 20321, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 20322, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 38805, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 42728, column 331 (Column 330).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 73287, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 73288, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 83562, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 83563, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 83564, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 83565, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 118399, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 120654, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 129056, column 330 (Column 329).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 217074, column 331 (Column 330).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 217075, column 331 (Column 330).

The statement has been terminated.
Query was cancelled by user.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-17 : 15:58:00

see if the delimiter is consistent in file and also you dont have any spurious data coming in the files

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

padgettbrian
Starting Member

23 Posts

Posted - 2012-02-17 : 16:38:14

What program or process would you recommend to check that? The source TXT file is 120 GB :((((

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources