Thursday, June 7, 2012

Using System\User variable in SSIS Send Email Task

Solution :
1) Create user variable for all common property like from, To, Subject & Body message.

2) Create a Send Mail Task and Go to Send Mail Task Editor >> Mail option and select MessageSourceType as Variable and MessageSource = User variable which is created yourself for message body.



3)  Expressions. Select FromLine property and assign variable value in Expression field. Same way you can apply other common property like ToLine, CCLine and Subject.





No comments: