topic MSSQL Bulk Insert -- Executing from remote linux talend server in Talend Studio

MSSQL Bulk Insert -- Executing from remote linux talend server

Anonymous — Mon, 13 Aug 2018 13:52:34 GMT

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

Re: MSSQL Bulk Insert -- Executing from remote linux talend server

Anonymous — Fri, 31 Aug 2018 11:07:17 GMT

Hello,

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

Best regards

Sabrina

Re: MSSQL Bulk Insert -- Executing from remote linux talend server

Anonymous — Thu, 21 May 2020 10:09:16 GMT

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.

Re: MSSQL Bulk Insert -- Executing from remote linux talend server

Anonymous — Thu, 21 May 2020 13:26:27 GMT

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