5 Replies Latest reply: Nov 30, 2016 5:46 PM by Rob Wunderlich RSS

    In a reload script and reload task, raise exception if "0 lines fetched"

    KHOA NGUYEN

      Hi.  How can I raise an exception if I have a "0 lines fetched" during any point in the reload task?

       

      2016-11-30 08:00:06 0104 FROM [myDatabase].[dbo].[myTransactionsTable]

      2016-11-30 08:00:06 0105 WHERE TranType IN (

      2016-11-30 08:00:06 0106 'buy'

      2016-11-30 08:00:06 0107 ,'sell'

      2016-11-30 08:00:06 0108 )

      2016-11-30 08:00:06 0109 AND InvCode NOT LIKE '%collateral%'

      2016-11-30 08:00:06 0110

      2016-11-30 08:00:06 0111 ORDER BY TDate DESC

      2016-11-30 08:00:07      30 fields found: *** OMITTED FOR BREVITY ***

      2016-11-30 08:00:07      0 lines fetched