Hi I have an SSIS package with an Execute SQL Task and a Send Mail Task.
Execute SQL Task: It is executing the following Query and sending the Count to a Singlerow Result SET Variable.
SELECT Count(*) AS CountColumn From (
dbo.TableA Tab1 WITH ( NOLOCK )
JOIN dbo.TableB Tab2 WITH ( NOLOCK )
ON Tab1.ID = TAB2.ID
WHERE Tab1.Col5 = 0) A
SEND Mail Task: Will Send a notification if the above count is >= 1.
What I want now is I want to send a notification email with the Result Set of the above query.
Is it possible to do this.
Any Help would be highly Appreciated..
Thanks in Advance