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:BULKINSERT CSVFROM 'C:\Inetpub\wwwroot\Cisco\201206.csv'WITH(FIELDTERMINATOR = ',',ROWTERMINATOR = '\n',FIRSTROW = 8)GO
But is show this errorMsg 4864, Level 16, State 1, Line 3Bulk 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 file1-Jan-12,12:47:27 AM,12:50:36 AM,169,3919,124956920,G711Ulaw 64k,G711Ulaw 64k,SEP002414B26F1E,172.17.204.2,NA,NA1-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 - 2012-07-10 : 03:32:39
