Normally this error occurs when the column in target table doesn’t have the same column length of the source table. To locate the particular column, try the following
SET ANSI_WARNINGS OFF
[Insert your MERGE Statement here]
SET ANSI_WARNINGS ON
Technorati Tags: SSIS