Hi,I am getting errors when i am trying to execute a bulk insert statement. I have a csv file, i want to move the data from csv to a sql table. The csv i have has 63 columns, but the sql table has 74 columns. The idea behind having 74 columns in sql table is i am using this as one big master holding table where different csv files with different schemas can be stored here before processing data and then distributing data into appropriate original tables.Is it possible to insert these 63 columns of rows into a sql table with 74 columns.When i do this the errors i get areServer: Msg 4863, Level 16, State 1, Line 1Bulk insert data conversion error (truncation) for row 1, column 74 (fld74).Server: Msg 4863, Level 16, State 1, Line 1Bulk insert data conversion error (truncation) for row 2, column 74 (fld74).Server: Msg 4863, Level 16, State 1, Line 1Bulk insert data conversion error (truncation) for row 3, column 74 (fld74).Server: Msg 4863, Level 16, State 1, Line 1Bulk insert data conversion error (truncation) for row 4, column 74 (fld74).Server: Msg 4863, Level 16, State 1, Line 1Bulk insert data conversion error (truncation) for row 5, column 74 (fld74).Server: Msg 4863, Level 16, State 1, Line 1Bulk insert data conversion error (truncation) for row 6, column 74 (fld74).Server: Msg 4863, Level 16, State 1, Line 1Bulk insert data conversion error (truncation) for row 7, column 74 (fld74).
Is this because the num of columns dont match. Please help me on this one.I actually tried to Use bulk insert on csv & sql table which have same num of columns and it works. Please let me know if there is a way around to insert data from a csv in to sql table where the columns in csv are less than those in sql table, beacause that is what i want to do.Thanks a lot in advance,Nitu
Bulk Insert Errors
Posted - 2006-06-15 : 14:09:05
