Write Output to Multiple SQL Tables

[alphabex18]

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

[dataMack · Accepted 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.

[alphabex18]

Thank you Jason. I will give that a try. 

[SQLisntBetter]

I know this thread is old but any chance we can get an example of this, or a more detailed explanation?

[shibikp]

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. 

[apathetichell]

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?