Incremental QVD file loads with 160 million plus records

[mstoler]

Hello,

Are there any issues with using Incremental QVD files with 160 million plus records?

I am using this technique below but I have received an error : Unsupported or bad format in qvd file when loading.

On smaller tables this has not been a problem.

Thanks,

Michael

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT Exists(PrimaryKey);

STORE QV_Table INTO File.QVD;

[mstoler · Accepted solution]

Hello,

Problem was most likely because of low disk space on the server.

I wll continue to monitor.

Thanks,

Michael