Sharing knowledge does not lessen your store, often it gets you more.
Success doesn't happen overnight and patience is key to living your dream life.
Success is a journey not a destination
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