Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We can generates the Qlikview qvd file out put into csv files. Now we want to write back these csv files into DHW ( MS SQL Server). How it is possible by automation? Any advise, greatly appreciates.
If you write them back to CSV files, you could load them from SSIS, and hereby extracting them to a table.
Thank you Thomas Jensen. Is there any method to achieve the same?
Hello,
You can use any ETL tool to perform this. As mentioned SSIS, and open source tools like Talend etc.
And also you can use Macro to perform this. Check below links:
http://community.qlik.com/thread/61660
http://community.qlik.com/thread/25063
Thanks,
ASINGH
Hi All,
I did not get. please provide the steps or document for this.
Do like this if you do not know how to do it in SSIS:
http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/
Then you can add a job to the SQL job agent, which can run this daily. (Remember to truncate table if you are doing a full load)
select flat file source instead of excel. Then you can choose csv files.