When using tMySQLOutputBulkExec to update rows, how do you specify which columns are to be updated and which should be used as keys?
@devmichael,in the edit schema of tMySQLOutputBulkExec ,you cna define key column and the other columns what are you mentioned will be updated based on key column.
I currently select columns I wish to be used to lookup records as keys, and everything remaining I expect to be updated. I then go into Advanced Settings and set 'Action on Data' to be 'Update records in table'. When I do this, certain fields end up blank. I don't think it's a constraint or not null issue but before I took more time with it, I wanted to make sure the above was reasonable.
@devmichael,in data based side there is proper defining key on the key columns ,then the solution which i provide will work perfectly. if you have any other contains in database side you need to sort out.