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?
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.
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?