MSSQL Bulk Insert -- Executing from remote linux talend server

[Anonymous]

Hello All,

I'm looking to run a bulk insert using the tMSSqlBulkExec and BulkOutput components on a remote talend server, however I've been running into some issues. My understanding is that MS SQL Server and Talend need to be installed onto the same server so they can access the file that is written by the BulkOutput. 

How can I run bulk inserts if I have my SQL Server installation on an EC2 windows server and Talend on a separate EC2 linux server? Any recommendations would be much appreciated!

Thanks,

Mikhail

[Anonymous]

Hello,

What's your input source? Are your file on your disk or DB server?

Best regards

Sabrina

[Anonymous]

Hi,

We are facing similar issue. Where we need to load a file data into Azure SQL DB. File is in Linux server

and Azure Sql DB on different server.

[Anonymous]

Hi pra7
The file is located on the machine specified by the URI in the Host field so it should be on the same machine as the database server, refer to the component documentation.
https://help.talend.com/reader/XhscnJg8Lk7LBPMo_9VPPw/80ud_kUCL9EX0r1bVXSomw
So, if the file is on different server, find a way to move the file to the machine where SQL DB is installed.

Regards
Shong