How to make the DTS package fail, when the source table is empty

How to make the DTS package fail, when the source table is empty while transfering data from source to destination.

Quote:

Originally Posted by sajithamol

How to make the DTS package fail, when the source table is empty while transfering data from source to destination.

Hi,

you will have to specify a T-SQL statement stating if it fails dont run DTS. Its easy to do it in MS SQL 2005 and it has added features.