How to assign a output column to an Environmental variable a
Posted: Thu Jan 13, 2011 1:08 am
Hi all,
I have requirement in which.I have to assign the output count of a query to a variable and have the same included in the Body of Email notification stage.
(E.g).
1).select count(*) as COUNT from xxxx
2).This Output "COUNT" has to be assigned to some variable say "ENV_Variable"
3).This "ENV_Variable" has to be assigned to the Email body of Email notification.
How can this be achieved.Please give your inputs on this.
Thanks In advance.
I have requirement in which.I have to assign the output count of a query to a variable and have the same included in the Body of Email notification stage.
(E.g).
1).select count(*) as COUNT from xxxx
2).This Output "COUNT" has to be assigned to some variable say "ENV_Variable"
3).This "ENV_Variable" has to be assigned to the Email body of Email notification.
How can this be achieved.Please give your inputs on this.
Thanks In advance.