1 Reply Latest reply: Sep 5, 2016 7:05 AM by Marcus Sommer RSS

    Only reload QVW if condition is met, cancel if not

    Ram Krishna

      Hi,

       

      Hoping someone can answer this....

       

      Have a QVF that pulls data from a SQL Datawarehouse (which gets populated from other sources via SSIS).

      The document reloads via the QMC once an hour. However sometimes the Datawarehouse load from SSIS is still in progress when the QMC reload kicks off.

       

      This is causing partial data to appear in the QVF.  Ideally we want the QVF to only reload the data if the SSIS job has completed. If it hasn't completed, abort the reload and leave the QVW as is.

       

       

      Thanks,

      Ram Krishna