Thank you Ankur, you had the answer from the start. It was indeed this, in my enrichment the alias did not have the @. I did not realize that was what you were saying before. I also realized that after Vipul's thorough message.
How can I mark 3 messages as the correct answer?
I really appreciate your time and effort, thank you.
Thank you Vipul for the SQL logs hint, this was very useful.
I examined the logs and they seemed to do the correct thing. Here's the INSERT statement during the delivery:
INSERT INTO NmsBroadLogRcp (iBroadLogId, iDeliveryId, sAddress, iStatus, iFlags, tsEvent, tsLastModified, iMsgId, sPersadoCampaignName,sPersadoVariationCode,sPersadoGenopediaId,iRecipientId ) SELECT BL.iMessageId, 1136493815, BL.sAddress, CASE WHEN BL.iFailureReason = 0 THEN 6 ELSE 0 END, CASE WHEN BL.iFailureReason = 127 THEN 8 WHEN BL.sTargetCode = E'__MAIN__' THEN 0 WHEN BL.sTargetCode = E'__BAT__' THEN 2 ELSE 4 END, GetDate(), GetDate(), BL.iMsgId, BL.sPersadoCampaignName,BL.sPersadoVariationCode,BL.sPersadoGenopediaId,BL.iRecipientId FROM wkDlv_1136493815 BL WHERE BL.iFailureReason IN (0, 127)
I tried this again and I'm still having problems, I wonder if I'm missing something. I entered a static string value as the "source" of one column in the mapping and it worked correctly. So it seems that the data can either not be read from the workflow table for some reason.
Has anyone ever gotten this to work succesfully? Is the [targetData/@columnName] notation actually supported as that UI text says?