6 Replies Latest reply: Aug 16, 2016 11:42 AM by Donald Guillory RSS

    qvd to database table

    Donald Guillory

      Hello,

      I have a requirement to write 100+ .qvd files to MSSQL server tables. The qvd is comprised of data from various file types that occasionally get updated or new files loaded.  After the load/transform the data will need to be inserted into database tables nightly or on a schedule.

      I know this can be done with scripting in the qvd or by exporting the qvd to csv (store & SQL insert) and importing to tables manually or with SSIS.  My question really is to ask if there is a better method to do this?  I would prefer not having to create the tables one by one and have to write all of the inserts. 

      Any suggestions would be appreciated.