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!