Error inserting data into table received an invalid column length from the bcp client for colid5

Question

Am trying to import my CSV file to perform some operations on it I successfuly import one file into my sql database and when I try to import another same csv file it show an error
I use the SSMS

Answer 1

Most likely the issue will be the data in one of the columns in the CSV is too large to fit into the destination column in database. For example, in the Modify Columns section change all varchar columns to NVARCHAR(MAX).