Help with flagging processed records (5 replies)
The BillNumber field will need to "physically" occur before your formula field if BillNumber is not from the prior node.
Should your expression be like the following?
%IDINVC = %BillNumber
Otherwise you're comparing %IDINVC to an undeclared variable called BillNumber.
Dane, following your support ticket, can you please attach a screenshot of your DBWriter?
Hi: I changed the criteria for the flag, and am not getting a different message. My criteria is: %IDINVC ""
Here is the new error:
Error occurred whilst processing transform [OELNUXDN].
Error whilst processing [AR0031] record [1].
Error whilst processing [AR0032] record [1].
[Microsoft][SQL Server Native Client 11.0][SQL Server]An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
Hi Dane,
If we could please have screenshots of the writer mapping, both levels please.
Thanks
Attached.
Hi: I changed an import job to base the Invoice number on a formula, and now my Processed flag is failing, with the message:
Error occurred whilst processing transform [OELNUXDN].
Error whilst processing [AR0031] record [1].
Error whilst processing [AR0032] record [1].
Replacement for field [%1] cannot be performed since it's not a field in corresponding transaction.
The expression for the flag is: %IDINVC = BillNumber
My question is, if I want to set this as equal to a different field, do I need to add that field in the previous node?