December 4, 2012 at 4:51 am
Hi all,
Ive seen a few variations/pointers on this but nobody doing what I am trying. I *think* this is the best way to do it, just not sure if its possible tbh! What I want to do is execute a stored proc (no probs) which basically does a bunch of lookups and calcs and then returns a dataset to the SSIS where each row contains information that I want to email using the "send mail task" to email addresses that are in each row of the result set.
So I guess my question is...is it possible to use the for (or foreach) loop container to grab each row of the result set and churn through them setting a variable to the email address and sending out the email ? If it is does anyone know of any examples, doesnt really matter how tenuous they are I should be able to muddle through, I just wondered if I was on to a hiding to nowhere with this plan.
Thanks
t
December 4, 2012 at 5:07 am
This was removed by the editor as SPAM
December 4, 2012 at 5:26 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply