Four 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

1 REPLY
Moderator

Re: I want to load bulk data in MS SQL

Hello,

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

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.