All datatypes are Varchar(50), direct load from CSV file, no fancies in the design, data will be picked up further and this stage table this All-varchar-table  will be deleted until...

Interesting idea. I like it ! thanks.

Also, i noticed in earlier BIDs versions, it often solves the issue (unless you really do not have permissions...) if you just delete the connection, and create a new one...

The problem I cannot overcome is that my output XL file name is built in the COPY G5 template task, the task that assigns name to output XL  file (and...

So scripting tasks is my best bet to write to multiple spreadsheets of same workbook within ForEarchLoop?

DO you think it is better to start doing it via a SCRIPT task right away?
because neither one of the attached scenarios works.
When i disable one data flow...

and if i use 2  OLEDB sources and 2 XL destinations in same Data Flow, would it then always process in parallel?
How can I make it sequential?

Thank you!

Because before we buy it my boss wants to see if there are any choices of tools that do similar thing. If we do not see anything else we will...

Sounds neat. thanks. and to check whether the loop has been entered i just put a script task into it and assign = 1 to a variable that =0?

hmm...

But that requires 2 loops , tables and columns, a lot of T-SQL writing and testing... 🙁

Currently i am using the below T-SQL, one column of one table at a time.  But need to obfuscate 200 tables, same column name in all 200. Same datatype.