How do I output to multiple Excel files with different schemas

Question

I posted this as a reply to another thread, but I thought I'd put it out there to the general community as well to see if anyone has any ideas.

I'm trying to create a batch macro to read a list of SQL Server table names and specify backup file names for them to be written to.  The sheets in the backup excel files will be the names of the SQL tables.

I can get this to run on a single pass no matter what the schema is, and I can get the workflow to run the macro successfully, but the files are not getting written.  I have no idea what's happening since I can't see what the macro is actually doing (maybe there's a way to see into this?).

Anyway, any help would be appreciated.  I've attached the test files.

Thanks!  Chris.

OpsConsoleBackUpMacro.yxmc

OpsConsoleBackUpOfTablesBeingDropped.yxmd

ListOfTablesAndFiles.xlsx

ChrisCrombie · Accepted Answer

Thanks for the reply sfyodor.

Actually, I found the problem after I posted.  Sometimes the simplest solution is not making silly errors like I did.  I had the "Disable All Tools that Write Output" selected in Runtime for testing [insert picture of me smacking my head here].

It's working fine now and I'm going to go ahead upload the corrected version for posterity in case anyone else can benefit.

Chris