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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Practical steps to developing your data integration strategy.