I have seen similar posts and I have tried the solutions. Nothing is working. Seems like it should be simple enough.
No matter what method I have used...qvdcreatetime, qvdfilesize...They always return null. The file exists. The path is correct. The capitalization is correct. I don't know what is going wrong with this.
SET vFileName = 'F:\FMCustom\01_Staging\QVD\Oracle\ItemOnhandQtyDetail_HIST.QVD';
//If the snapshot table exists, load it for the last 3 years and append the new snapshot.
IF (NOT isNull(qvdCreateTime($(vFileName)))) THEN
ItemOnhandQtyDetail_HIST: LOAD DISTINCT * FROM [lib://FM Staging/QVD/Oracle/ItemOnhandQtyDetail_HIST.QVD](qvd) Where Year(dateLoaded) >= Year(Today())-2 ;