Hey - I'm trying to achieve something clever with context variables and a tMysqlOutput component. I have a database that contains 60+ tables and I'm trying to build out a dynamic job that lists the tables with a simple SHOW TABLES command into a delimited file. I then read that file and run it through an iterate flow to allow me to set a context.TableName variable in the flow. I have a single tMysqlOutput component and want the Table to be defined by the value of the context.TableName. So, this transformation in the MySQL component needs to happen during the flow.
However, I have a suspicion the context.TableName will be transformed at compilation time as when I run the job it complains that the Table in the component is not set.
Any help would be great!
