Sunday, October 18, 2015

String or Binary data would be truncated when using MERGE in SSIS

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: