I'm having very huge amount of data to load into tables. I want best approach bcp or tmssqlbulkexe
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.