We are trying to do BULK Insert into MSSQL DB via talend. As the file is on our disk and not on DB server therefore MSSQL not been able to access the file. Please suggest any way by which we can bulk insert our data via Talend without moving the file to DB server??
Solved! Go to Solution.
What's your input source? Can you bulk insert your data into MSSQL DB by using talend bulk component?
Please take a look at this component TalendHelpCenter:tMSSqlOutputBulkExec which allows gains in performance during Insert operations to a Microsoft SQL Server database.
Here is also a related scenario about:TalendHelpCenter: Scenario: Inserting data in bulk in MySQL database.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables