I know that I can use the Output tool to write out to one excel document, with multiple sheets. I am wondering if i can also write out to multiple SQL tables with one output tool, or would I need to filter to multiple output tools?
Thanks in advance
Solved! Go to Solution.
If you only wanted a single output tool (ex. for ease of updating server name etc.) then put it inside a batch macro and use a control parameter to change the tables in the output for your SQL write to the database.
Thank you Jason. I will give that a try.
I know this thread is old but any chance we can get an example of this, or a more detailed explanation?
Just wondering if anyone has a solution for this. Am able to connect to the tables dynamically using macros, but the challenge I have is loading the input stream in to the connected table.
Hi - are you going from canvas to DB (ie datastream in?). You can use a batch macro with an action tool set to update the table name in the datastream in (set to create new table - or overwrite/drop as you'd prefer). The action tool will update this element when run in a batch macro.
If you need additional help - perhaps you can post some of your workflow in a separate thread?