Bulk Insert Issue - 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 2008 Forums

Transact-SQL (2008)

Bulk Insert Issue

Author

Topic

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2014-04-21 : 21:03:50

Hi,

I am trying to import CSV files into my table

I have three columns in my table.

TableName : Keys

key nvarchar(50)
English nvarchar(4000)
Spanish nvarchar(4000)

My logic:

BULK INSERT Keys
   FROM 'F:\Keys.csv'
   with ( FIELDTERMINATOR =',', FIRSTROW = 2,CODEPAGE = 1252);

the reason i am using codepage=1252 is to insert Spanish text.

I am able to do the bulk insert. I could see some row values of English column has double quotes and some text of the row cut and moved with Spanish Text. Not sure why.

Any suggestion please how to insert exactly what i have in my CSV file.

Thanks in advance

sqllover
Constraint Violating Yak Guru

338 Posts

Posted - 2014-04-22 : 11:25:31

I found the issue. it's not because of bulk insert. i have data issue with my csv file. So no issues now.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources