Bulk load data conversion error

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

General SQL Server Forums

New to SQL Server Programming

Bulk load data conversion error

Author

Topic

AaronMossRenfroe
Starting Member

5 Posts

Posted - 2010-11-29 : 14:27:26

Hello Everyone!

I'm trying to do a Bulk Insert into a local table for testing.

BULK INSERT Griffin2010
FROM 'C:\CatalogRevT.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

I get the following error:
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (ID)

I have tried setting identity_insert to ON and OFF, i have also tried on my identity column setting it to yes and no.

Any Suggestions?

Here is a row of the data:

ACURA,INTEGRA,1990,Inline_4,GS,0-400,9E-HE790-01,1.50",1,13.00 x 26.88

Thanks!!!

AaronMossRenfroe
Starting Member

5 Posts

Posted - 2010-11-29 : 14:35:56

I'm sorry, i set me identity column's replicate option to yes and no.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources