Dear Gurus,
I am trying to import a CSV File to SQL Server. The temp table is simply called CSV and all field are just nvarchar (example as below).
CREATE TABLE [dbo].[CSV](
[csvDate] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csvYear] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csvOriTime] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csvTermTime] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csvDuration] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csvOrig] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csvDest] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csv1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csv2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csv3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csv4] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csv5] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csv6] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csv7] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[csv8] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
I run my code as below:
BULK
INSERT CSV
FROM 'C:\Inetpub\wwwroot\Cisco\201206.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRSTROW = 8
)
GO
But is show this error
Msg 4864, Level 16, State 1, Line 3
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 8, column 15 (csv8).
Here is two rows of sample of the text taken from the CSV file
1-Jan-12,12:47:27 AM,12:50:36 AM,169,3919,124956920,G711Ulaw 64k,G711Ulaw 64k,SEP002414B26F1E,172.17.204.2,NA,NA
1-Jan-12,1:21:44 AM,1:23:01 AM,61,3919,124956920,G711Ulaw 64k,G711Ulaw 64k,SEP002414B26F1E,172.17.204.2,NA,NA
I don't understand it. My table is simply nvarchar, what is there to convert? What is the problem? Please advise.
CSV problem Bulk load data conversion error
Posted - 07/10/2012 : 03:32:39
