topic Re: How MSSQL bulk component works in talend? in Talend Studio

How MSSQL bulk component works in talend?

Anonymous — Tue, 14 Nov 2017 10:16:31 GMT

Hi All,

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.

please let me know the best approach

Re: How MSSQL bulk component works in talend?

Anonymous — Thu, 16 Nov 2017 09:05:16 GMT

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.

Regards
Shong

Re: How MSSQL bulk component works in talend?

Anonymous — Fri, 17 Nov 2017 12:13:20 GMT

Hi Shong,

Thanks for your reply.

I deployed talend job on jobserver and my MSSql server is on windows server, So according to your answer it will not work right?

Re: How MSSQL bulk component works in talend?

Anonymous — Mon, 18 Mar 2019 09:08:13 GMT

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.