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?