SQL Server Database" cannot be overridden by specifying data in <TextData>
Hi,
I created a label template and included data from a database field sourced from a mysql db. I set the custom query to use query prompts to locate the correct record. (where ao.ordernumber = '?ord' and
ao.releasenumber = '?seq')
In the Integration builder I am using file detection to be the record source for the labels to be printed.
In print document, Query Prompts - Set the prompts to the values imported from the csv file. In Print options - I added the database override.
Yet when running the test, the job fails with:
What am I missing?
Thank you in advance
0
Please sign in to leave a comment.
Comments
0 comments