Check for existence of QVD

[FMDF]

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
;

//Append todays data to the HIST table.

Concatenate(ItemOnhandQtyDetail_HIST)
LOAD
itemKey,
organizationId,
inventoryItemId,
subinventoryCode,
primaryTransactionQty,
locatorId,
dateLoaded
FROM [lib://FM Staging/QVD/Oracle/ItemOnhandQtyDetail.QVD](qvd);

ELSE
//Snapshot Table does not exist yet. Load it from the current data load.

ItemOnhandQtyDetail_HIST:
LOAD
*
FROM [lib://FM Staging/QVD/Oracle/ItemOnhandQtyDetail.QVD](qvd);
;
END IF