Hi
We're trying to set up a proxy user to run an SQL Server job, but there are steps in the SSIS package with are MERGE statements.
The user account set up, which has sysadmin rights against the databases, receives a 'Violation of PRIMARY KEY constraint' error when doing this statement. Another user, with the exact same security permissions, does not get this violation, and not does the SQL Server Agent.
When separating the statement out to its separate parts, inserting in TEMPDB, and then doing a MERGE, no such violation occurs.
I have been unable to find any reference to this problem, and any assistance would be greatly appreciated. We're using SQL Server 2016.
Thanks.