Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Labels (3)
1 Reply
Anonymous
Not applicable
Author

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