Is there anyway to declare a Global Variable in a DTS package and then call it within an Execute SQL Task.
I want to make a Global Variable a string containing a list of email addresses. Then, in the Execute SQL Task, I want to use this Global Variable as the input to the @recipients of the xp_sendmail stored procedure.
Right now i just have the variable set with in the Execute SQL Task.
Set @EmailTO = Nfirstname.lastname@example.org'
i want it like this: