Hi everyone
I have a package that contains 2 Task (Active x script & send mail task)
In The active x script task there is a loop in it for a condition until it
is achieved, i wont for each loop, the send mail task be executed
is it doable?? if yes, how???????????

No. Looping inside a task does not allow you to reach out and execute other
tasks, since the first task is still executing. Why not just add some ActX
Script code to send the mail. Plenty of methods to send mail in VBS.

Or

Personally I do all admin mailing through xp_smtp_sendmail
(http://www.sqldev.net) and you can just wrap this all in a single T-SQL
task.


Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Mariame" <mariame_waguih (AT) hotmail (DOT) com> wrote