I am using Excel add-in for data migration most of the time no issues.

in a few examples i need to do some data retrieval/lookup and have used an expression in the ‘default value’ column in the migration job.

However, as yet i am struggling to do the same with a simple SQL select. Is it not possible or is my syntax incorrect. I have no guidance so I am making it up as a I go, I could be doing it incorrectly.

I did write a select first in quick reports to prove it was correct, although it is so simple I did not really need to.

When I click validate or execute - I don’t get any feedback, (the debug feature does not work) - but if I remove the select my other data updates - so something about my approach is failing. 

Thank you for any suggestions!