Reading from CSV Text file and linking to a SQl table Follow
I have designed a label to read a CSV file and have it linked to a SQL table.
The CSV file has basic information- specifically it has a "part number" field.
The "part number" is linked to a sql table to extract the "label size" to print.
Once we have the label size, we need to print to a different printer using a different template.
I was wanting to use this template, with the joins to the SQL table, to be used in the Integration builder
From what I can see, Integration Builder can only connect to a single datasource during integration.
I need it to connect to the SQL table as well to be able to get the "label size" field so I can use it in the Print Document- Actions- Run Action- Conditionally, based on a variable.
(Unfortunately I cannot include the label size in the CSV input file. Its only available by joining/looking up a SQL table.)
How do I get the Integration builder to connect to a second table with the Integration-InputData as it seems it can only connect to a single data source?
My Actions are Transform Text to Record Set, For Each Database Record, then Print Document(Small Label) and Print Document(Large Label) with conditional printing.
Hope this makes sense!
Please sign in to leave a comment.