Four Stars

Updating with tMySQLOutputBulkExec

When using tMySQLOutputBulkExec to update rows, how do you specify which columns are to be updated and which should be used as keys?

4 REPLIES
Twelve Stars

Re: Updating with tMySQLOutputBulkExec

@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.

Manohar B
Four Stars

Re: Updating with tMySQLOutputBulkExec

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.

Twelve Stars

Re: Updating with tMySQLOutputBulkExec

@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.

Manohar B
Twelve Stars

Re: Updating with tMySQLOutputBulkExec

@devmichael,still do you have issue?

Manohar B