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 |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2010-08-19 : 14:09:39
|
| I am an SSIS newbie..... I am trying to send a specific email if the number of records from my OLE DB Data Flow task is >= 1.If 0 records returned, send a different email.Currently, I am using a variable called var_rowcount.I am using the Row Count trasformation, assigning the row count to the var_rowcount variable within the Data Flow tab.I then am using the Send Mail task on the Control Flow tab, how do I set it up to send the email using this variable as a conditional operator.Hope this makes sense..... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-19 : 14:16:03
|
| you need to add a expression and set value of email message based on this condition in variable tab. then use variable to map to message content in expression builder.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Different Email based on Global Variable Values