Five Stars

I want to load bulk data in MS SQL

 I'm having very huge amount of data to load into tables. I want best approach bcp or tmssqlbulkexe


Re: I want to load bulk data in MS SQL


Please take a look at the related scenario about:TalendHelpCenter: Scenario: Inserting transformed data in MySQL database

This scenario describes a four-component job which aims at fueling a database with data contained in a file, including transformed data. You can use tMssqlBulkExec and tMssqlOutputBulk components to load  bulk data in MS SQL DB.

Best regards


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