Six Stars

How MSSQL bulk component works in talend?

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 

 

Thanks & Regards
A Ravi Kumar
Mobile Number : +91 852-762-1083
Email-id : a.ravikumar104@gmail.com
Skype Id : ammanannaravikumar
2 REPLIES
Community Manager

Re: How MSSQL bulk component works in talend?

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: How MSSQL bulk component works in talend?

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?

Thanks & Regards
A Ravi Kumar
Mobile Number : +91 852-762-1083
Email-id : a.ravikumar104@gmail.com
Skype Id : ammanannaravikumar