Updating with tMySQLOutputBulkExec

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?

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

Thirteen 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
Thirteen Stars

Re: Updating with tMySQLOutputBulkExec

@devmichael,still do you have issue?

Manohar B