I have a csv file that is automatically been filled by an application. The csv file has a fixed size. That means that if the file is full, the oldest data is overwritten. The data of that file needs to be stored in a SQL Server Express Database. So no possibility to use SSIS.
My question is, is it possible to this with Qlikview? If yes, can you create a job for it, like in SQL Server? I have read something about macro's, but don't know if it is possible.
you could use a free ETL tool like Pentaho Kettle to do this load and transformation into SQL Server. An SQL INSERT in QlikView script is possible but this can be done only record-wise in a loop adn you will get no response if it's succeeded.