Home Forums Article Discussions Article Discussions by Author Discuss content posted by Paul Clancy Sending scheduled SQL query results via HTML e-mail using SSIS RE: Sending scheduled SQL query results via HTML e-mail using SSIS
jhasbufuidh
SSC Eights!
Points: 992
More actions
April 24, 2014 at 3:19 pm
#1708623
Test existence of data and set a variable to 1 or 0. Then add an expression to the flow line to evaluate the variable so the mail task runs only if the condition is met.
BI Guy