December 10, 2001 at 10:45 am
Is it possible to pass a global var into an email task: I want to pass a table name into an email message.
Steve Johnson
Steve Johnson
December 10, 2001 at 11:18 am
There are two ways I have found.
1. Use Dynamic Properties task to reset a value in the sendmail task based on a query, global variable, etc.
2. Use an Active X script to "transform" the task in the same manner.
Both of these do the same thing. #1 is easier, #2 is more flexible.
Steve Jones
December 10, 2001 at 11:54 am
Thanks Steve, I just opened up SQL Server 2000 DTS, It has a great example of this...
Steve Johnson
Steve Johnson
December 10, 2001 at 11:59 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply