Six Stars

Difference between tMysqlBulkexec and tMysqlOutputBulkExec

Hi Team

 

Can you please explain what is the difference between 

tMysqlBulkexec  and tMysqlOutputBulkExec.

 

Thanks in Advance

 

Deepthi

2 REPLIES
Moderator

Re: Difference between tMysqlBulkexec and tMysqlOutputBulkExec

Hello,

The tMysqlOutputBulk and tMysqlBulkExec components are used together in a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT statement used to feed a database.

These two steps are fused together in the tMysqlOutputBulkExec component, detailed in a separate section. The advantage of using two separate steps is that the data can be transformed before it is loaded in the database.

Let us know if it is OK with you.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Moderator

Re: Difference between tMysqlBulkexec and tMysqlOutputBulkExec

Hello,

Feel free to let us know if it is OK with you and post your issue here.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.