I am trying to setup reading data from a text file.
When in "Print Document > Properties > Print Options > Database Overrides" there is no dropdown list to select "Integration Input Data"
What is the correct selections required:
You are going to need to effectively declare them first using the
Actions > Transform to Record Set
Actions > For each Database Record and then the Print Document needs to be a daughter action of this.
I would suggest checking out some of the webinars that you can find here as they be useful:
Now I receive the following error when running "Test Action" from "For Each Database Record"
Cannot run the 'For Each Database Record' action because the record set source has not been set or is empty.0
This new error you are experiencing could be related to the SQL statement not being correct, could you make sure the values for the embedded source are exactly the same as the SQL statements in the database setup? Sometimes extra whitespaces or typos can lead to this error.
I hope this helps!0