How to transfer QVD data into SQL table quickly?

[fionna51]

Hi Guys,

Greetings.

I already have a qvd file, and want to transfer data into SQL server for other downstream use. The QVD size is around 37MB, 3.5 M rows and 100 fields. I tried using SQL bulk insert and single insert statement in Qlikview script, and the performance is not good enough.

Is there any other ETL tool or options to transfer QVD data into other kind of databases?

Thank you very much.

[rwunderlich]

One option would be to store the QVD also as a csv file.  And then there is probably a fast csv import tool that works with your database. 

-Rob