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!
What's your input source? Are your file on your disk or DB server?
Join us live for a sneak peek!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.