tMysqlOutput doesn't populate table if using existing connection
Here is a weird one for you. I have a simple job:
tMysqlConnection -> tSalesforceInput -> tMysqlOutput -> tLogRow
If I use the existing connection from the tMysqlConnection, then the tMysqlOutput will create the table, but there will be no data in it. If I don't use an existing connection but specify connection parameters in the tMysqlOutput, then the table gets created and there is data in it. In both cases the tLogRow shows the exact same row set that comes from the tSalesforceInput.
This tells me that the login credentials from the tMysqlConnection are correct because the tMysqlOutput creates the table - it could not do that if the host/userid/password/database were incorrect. It just won't put any data in it.
At this point I'm totally stumped.....
Unless you've checked "Auto-commit" in the advanced settings of tMysqlConnection or used a tMysqlCommit, the rows you attempt to insert will not be committed to the database when using an existing connection. The table creation is always automatically committed.
