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.
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 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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.