|
Hi Anil.
countrylist.csv file column has unsupported data format so please find another csv or download this file and save as .csv (comma seperated format)
http://www.webhostingtalk.com/attachment.php?attachmentid=8605&d=1129586321
|
|
|
|
|
When I run the following
BULK
INSERT Tbl_COUNTRY
FROM 'C:\\countrylist.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
I get following error message
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 6, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 7, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 8, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 9, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 10, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 11, column 2 (Country).
Msg 4865, Level 16, State 1, Line 1
Cannot bulk load because the maximum number of errors (10) was exceeded.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
seo services, limewire
seo services, limewire
nicki minaj your love, limewire
|
|
|
|
|
|
5 for giving the link .. Now it became a complete solution.
|
|
|
|
|
Reason for my vote of 5
Good solution after giving the CSV link.
|
|
|
|
|
thank you for suggestion
http://www.floresense.com/resc_center/_Downloads/countrylist.csv
|
|
|
|
|
Hi Anil.
countrylist.csv file column has unsupported data format so please find another csv or download this file and saved as .csv (comma seperated format)
http://www.webhostingtalk.com/attachment.php?attachmentid=8605&d=1129586321
|
|
|
|
|
Provide the link to download CSV file.
|
|
|
|
|
When I run the following
BULK
INSERT Tbl_COUNTRY
FROM 'C:\\countrylist.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
I get following error message
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 6, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 7, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 8, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 9, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 10, column 2 (Country).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 11, column 2 (Country).
Msg 4865, Level 16, State 1, Line 1
Cannot bulk load because the maximum number of errors (10) was exceeded.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
seo services, limewire
nicki minaj your love, limewire
|
|
|
|
|