Batch Macro and Run Command Tool

[xariet]

Hi All

I am trying to create a batch macro that will read the names of the tables to delete from SQL database. I need to do it with run command tool. I have put the following configuration with dummy Input and the batch file in the command line. So, the Run Command tool is working, it deletes the [cat] table in the database as written in the Command Arguments line. But Macro doesn't delete other tables which are read into it. My control parameter configuration is below. 

I guess I do not need to put my batch file in the command line, but then the tool requires the Write Source output to be filled in. I have tried to put there a dummy csv file, but it didn't work. Any ideas on how to get the macro to work..? 

[gabrielvilella · Accepted solution]

You can try having the command on a text input and update this tool with the control parameter. The run command can create the bat file from the text input. 

[xariet]

Thank you @gabrielvilella , that worked perfectly!