MSSQL Bulk Insert -- Executing from remote linux talend server

Highlighted
Two Stars

MSSQL Bulk Insert -- Executing from remote linux talend server

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

Moderator

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

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch