Is the 'User Destination' activity flawed in the 19.0.1.8 version.
I have the 19.0.1.9 version on my local mashine, and been developing some activitys to import some users, at the end of my pipeline i use the standart User Destination activity, at it works perfect.
But on the clients version it fails with the error:
12:40 PM User destination Error processing XML or executing SQL: Must declare the scalar variable "@Identifier".
Here's an example of the XML passed to the User Destination activity:
<Users>
<User>
<AccessUserID>11105318</AccessUserID>
<AccessUserParentID />
<AccessUserUserName>11105318</AccessUserUserName>
<AccessUserPassword>xxxxxx</AccessUserPassword>
<AccessUserName>L&K Björkman Försälgnings AB</AccessUserName>
<AccessUserDepartment />
<AccessUserEmail />
<AccessUserPhone>11105318</AccessUserPhone>
<AccessUserFax />
<AccessUserType>5</AccessUserType>
<AccessUserValidFrom />
<AccessUserValidTo />
<AccessUserPages />
<AccessUserAreas />
<AccessUserSettings />
<AccessUserModules />
<AccessUserInformation />
<AccessUserMyFolder />
<AccessUserAddress>Örtugsgatan 68</AccessUserAddress>
<AccessUserAddress2 />
<AccessUserZip />
<AccessUserCity>S-603 79 Norrköping</AccessUserCity>
<AccessUserCountry>SWEDEN</AccessUserCountry>
<AccessUserJobTitle />
<AccessUserCompany>L&K Björkman Försälgnings AB</AccessUserCompany>
<AccessUserPhonePriv />
<AccessUserMobile />
<AccessUserCustomerNumber />
<AccessUserRedirectOnLogin />
<AccessUserCurrencyCharacter />
<AccessUserRead />
<AccessUserAdsiMap />
<AccessUserPasswordDate />
<AccessUserLastName />
<AccessUserMiddleName />
<AccessUserActive>True</AccessUserActive>
<AccessUserBusiness />
<AccessUserInitials />
<AccessUserComment />
<AccessUserLevel />
<AccessUserInheritAddress />
<AccessUserWeb />
<AccessUserSort />
<AccessUserStatus />
<AccessUserStatusBegin />
<AccessUserStatusEnd />
<AccessUserStatusComment />
<AccessUserEditorConfigurationID />
<AccessUserHideStat />
<AccessUserGroups>
<GroupID GroupName="@19387@" />
</AccessUserGroups>
<AccessUserInformationFields />
</User>
</Users>