Send email for 0 rows in link
Posted: Thu Dec 20, 2007 11:11 am
Hi,
Our requirement is to send the email to users if the file is empty i.e. there are no rows processed, we want to implement the logic in ETL only.
I used the below logic in stage variable, constraint and even column transformation but it only runs if if there are actually rows processed i.e. @INROWNUM = 1 or > 1 for =0 it do nothing
IF @INROWNUM = 0 THEN DSSendMailTester('a@yahoo.com', 'a@yahoo.com', 'ul', 'a.com', 'Zero') else 0
Please guide if there is anyother way of doing it.
Regards,
Munish
Our requirement is to send the email to users if the file is empty i.e. there are no rows processed, we want to implement the logic in ETL only.
I used the below logic in stage variable, constraint and even column transformation but it only runs if if there are actually rows processed i.e. @INROWNUM = 1 or > 1 for =0 it do nothing
IF @INROWNUM = 0 THEN DSSendMailTester('a@yahoo.com', 'a@yahoo.com', 'ul', 'a.com', 'Zero') else 0
Please guide if there is anyother way of doing it.
Regards,
Munish