Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 how to by pass multiple values using one parameter

Author  Topic 

Oliver wang
Yak Posting Veteran

50 Posts

Posted - 2010-11-17 : 03:00:37
Hi everyone,

I got a problem, and here is the situation. I select 3 email addresses from a table, and i want to use a "foreach loop container" to send mails to 3 persons respectively. One possible solution is put the 3 rows in a object type variable, parse them in C# and then bypass the value to a "send mail task". But i don't want to use this solution because of this complexity. Does anyone know some alternative way, say, using some parameters to address this issue? I'd appreciate if you could explain the steps in detail.

Thanks for your time and effort.

Regards,

Oliver

chadmat
The Chadinator

1974 Posts

Posted - 2010-11-17 : 03:23:38
A cursor?

-Chad
Go to Top of Page
   

- Advertisement -