When attempting to run an ETL refresh, a user may notice that it fails with the below error:
Error: 2015-03-30 17:45:05.21
Source: Maintain Constituent Primary Email Address Execute SQL Task
Description: Executing the query "merge BBDW.[DIM_CONSTITUENT] as t
using BBDW.[v_FA..." failed with the following error: "The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Warning: 2015-03-30 17:45:05.21
Source: Load Constituent
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.