March 25, 2009 at 8:34 am
I understand there is a way to "hard code" parameters in an SQL Table and call them in an SSIS package.
I have stored SendMail parameters within a table:
One table with 2 columns (parameter and value)
Insert the following:
SMTPConnection - XXXXXX.com
From - XXXXX.XXXXX@XXX.com
How would I call the parameters in my SendMail task in SSIS?
Thanks
March 25, 2009 at 4:02 pm
Create an execute sql task to retrieve the values and stuff them into variables.
Using the 'expressions' in the Sendmail task, assign the values for From etc to the variables you've previously received.
FromLine @[User::FromLine]
ToLine @[User::SupportEmailAddress]
March 25, 2009 at 5:35 pm
True, but it is easier to use configurations. Why wouldn't you use them instead?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 25, 2009 at 6:58 pm
how do i use configuration in sendmail?
March 25, 2009 at 7:03 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply