[dba-SQLServer] DTS Conditional email

Richard Lavsa rlavsa at tigg.com
Thu Sep 28 13:59:58 CDT 2006


Hello all,

I was able to build a workflow very quickly to run a query, get the
results, export them into an excel file, then email the file to a
distribution list.  

I am stuck on how to make it do this only when the query returns rows.
The reason for this to be conditional, is that this only happens when a
process does not complete of which then needs to throw a flag to certain
people to check into the issue.  

Any help would be greatly appreciated.

Rich
CONFIDENTIALITY NOTICE: The information contained in this transmission may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please be advised that any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you received this transmission in error, please contact the sender at TIGG Corporation immediately by replying to this email and deleting it from your computer.



More information about the dba-SQLServer mailing list