Hi,
I would like to know how i can commit after loading data into a DB.
Currently I am loading data from a file to MySql but after the data load the data is not committing.
I have used mySqlCOmmit component but the Component List is empty with no values.
Thanks & Regards,
Srivignesh KN
Hi
Without using an existing connection, the data will be commit automatically every N rows, this parameter can be configured in the advanced panel of tMysqlOutput.
If you want to use an existing connection, you should use a tMysqlconnection to create a DB connection and use tMysqlCommit to commit the changes.
Regards
Shong
