DTS Package failing
I have a DTS package that creates a temp table and then wites the values from that temp table to a flat file,
This DTS is scheduled every 15 min, Some times thee is no data modification in Source Table when the DTS is executed.
I have an ActiveX script that checks for the records on the datasourse, if the records on the source are greater than 0 the DTS executes correctly, but when there arre no records the dts package executes the on failure task, sends a notification email and then I get an error message saying te package has failed.
Is there any way in which the package stops executing when there are no records in the datasource and exits, rather than Giving an error message saying the package has failed...