Click here to Skip to main content
15,442,754 members

Comments by Anil Srivastava (Top 2 by date)

Anil Srivastava 7-May-11 16:16pm View     CRLF
Deleted
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
Anil Srivastava 7-May-11 16:15pm View     CRLF
Deleted
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