Error 'String or binary data would be truncated' in Microsoft SQL
figure out the issue using following step.in your insert satement ,use 'LEN' function to find the length of the input columns.
suppose you are selecting data from a temp table for input. use the below query to find out maximum size of that column and compare with the actual size of the column in your original table (table you are going to insert data).
SELECT MAX(LEN(column1)) FROM #yourInputData