I would like to know how tMSSqlBulkExec components works in Talend.
As of my knowledge it's work as follows,if i am wrong please correct me.
1) By using tMSSqlOutputBulk we will create a bulk file in server where talend job is running.
ex: /opt/bulk/employee.txt
2) Copy file from Linux server("/opt/bulk/employee.txt") to remote Sql server("C:/bulk/employee.txt") where MSSql database is running, by using FTP server.
3) Use tMSSqlBulkExec component to load data in a table.
Note : We also have tMSSqlOutputBulkExec component to do same task , but the job should deploy on Sql server where MSSql database is running.
Hi
The tMSSqlOutputBulk and tMSSqlBulkExec 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 operation used to feed a database. These two steps are fused together in the tMSSqlOutputBulkExec component.
The database server must be installed on the same machine where the Studio is installed or where the Job using tMSSqlOutputBulkExec is deployed, so that the component functions properly.
Is it possible to Know as Talend works on tDB2BulkExec instead tMySqlServerBulkExec?
I have wrote here a topic but i haven't reply that tsoddisfied greatly to me.
