DBlookup function error

Hi, I am trying to use the dblookup function in a scribe dts. This works fine in the workbench when I run it but it fails when run in the console. The error I get is "Message Processor Error: An invalid formula was found in one or more data links."

 

I also get the same error using the SQLQUERY function but only in the console.

 

I thought it might be a permissions problem but the account used for the connection and the service account are both members of the "System Administrator" group within CRM.. The table I am using in the DBLOOKUP is the same as the Source target and that is not giving an error if I remove the formula.

 

Is there anyway to trace the error when it is run from within the console or any way of getting more detail on the error?

 

Any help will be appreciated,

 

Thanks

 

Tony

 

(2) Answers

Login