How do I use a variable in the TO feild of the SSIS Send Mail Task

#1

I want to use an Execute SQL Task to load an email address list from a table
and use the variable as the TO field in the Send Mail Task. Got the list
into a variable okay, but can't figure out how to make it work as the TO in
Send Mail. Any ideas?

#2

Hello Arghknork,

Have a look at these articles and you should get the idea.

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

Changing the DTS Send Mail Task
(http://www.sqldts.com/default.aspx?235)

OR

Shredding a Recordset
(http://www.sqlis.com/default.aspx?59)

Allan

Quote:

I want to use an Execute SQL Task to load an email address list from a
table and use the variable as the TO field in the Send Mail Task. Got
the list into a variable okay, but can't figure out how to make it
work as the TO in Send Mail. Any ideas?

#3

Thanks Allan. That last link did the trick. I never was much of a DTS freak
and am just learning SSIS. I'm going to like it. Looks like sqlis.com will
help a lot.

"Allan Mitchell" wrote:

Quote:

Hello Arghknork,

Have a look at these articles and you should get the idea.

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

Changing the DTS Send Mail Task
(http://www.sqldts.com/default.aspx?235)

OR

Shredding a Recordset
(http://www.sqlis.com/default.aspx?59)

Allan

I want to use an Execute SQL Task to load an email address list from a
table and use the variable as the TO field in the Send Mail Task. Got
the list into a variable okay, but can't figure out how to make it
work as the TO in Send Mail. Any ideas?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I use a variable in the TO feild of the SSIS Send Mail Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How do I use a variable in the TO feild of the SSIS Send Mail Task - 07-13-2006 , 03:58 PM

Re: How do I use a variable in the TO feild of the SSIS Send Mail Task - 07-15-2006 , 04:47 AM

Re: How do I use a variable in the TO feild of the SSIS Send Mail - 07-15-2006 , 08:16 AM