Hi,
I want send email if certain conditions are met (by send mail task)... if compnay records does not exists in some table (returns null)... not task failure.... how do I achieve this without using Script task?
does any one have an idea about it,
regards
You need conditional workflow: http://www.sqlis.com/default.aspx?306
You can base your expression on a boolean variable that can be set from various places, including a script task.
-Jamie
|||
In contiuation i would like to ask another question i.e. I want to send the results of my query (complete result sets) from email task? How will I able to achieve the task.?
ur help will be appreciated
|||Zadoras wrote:
In contiuation i would like to ask another question i.e. I want to send the results of my query (complete result sets) from email task? How will I able to achieve the task.?
ur help will be appreciated
Hmmm interesting one. probably the easiest way is to push that data into a flat file destination and then email that file as an attachment.
-Jamie
|||
that's what i was thinking... but i m searching for other way (may be the easiest way)
BTW... thanx for your support
if ne one come across to ne better idea than that please let me know
No comments:
Post a Comment