I'm getting this error when trying to validate a delete script: Data source [Grain(PO Detail_Snapshot)] does not exist
I'm using the same syntax I always do when deleting, basically deleting the dimension and fact tables:
COMPLETE
DELETE FROM [Level(Purchase Order Snapshot.Purchase Order Snapshot)]
WHERE 1=1
DELETE FROM [Grain(PO Detail_Snapshot)]
WHERE 1=1
END COMPLETE
PO Detail_Snapshot is 100% the name of the script that writes the fact table. Any idea why this isn't working?
Thanks