Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rgombina
Constraint Violating Yak Guru
319 Posts |
 Posted - 2008-01-10 : 12:15:00
|
| On Foreach File Enumerator, how can I send me email if no file found? Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-10 : 12:23:57
|
| Add a variable and use a script task to store the file counter in variable inside foreach container. Attach a send mail task to container and give option 'constriant & expression' and give expression 'counter==0' and on success |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-01-10 : 12:41:51
|
| Thank you. I also found a similar approach using FileName equals emtpy string. |
|
|
|
|
|
|
Email if file not found/exist