Need to create custom component for "sending mail"

Question

Post reply

Need to create custom component for "sending mail"

aveerabadran

Ten Centuries

Points: 1271
More actions
November 16, 2008 at 10:55 pm

#132208

Hi All,
I want to build a custom component for sending mail , when some error happens in the control flow tasks. [Since sending mail in error cases is same for all my packages , i am trying to build custom component] . Can someone provide some usefull links to achieve this?
Thanks,
Arunvijay

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

Why not use the standard Send Mail Task?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

aveerabadran Ten Centuries Points: 1271 More actions · Answer 2

if i use Send mail task , i need to manually put the smtp server,from & to address , mail subject,etc ..... These info are taken from table and assigned to variables , and used in the packages. So i believe that , passing these variables to a custom mail component will make me re-use this in all my packages.

-Arunvijay

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

You can pass variables to the send mail task. Right-click on the task select Properties menu. Scroll-down and find Expressions property. Press '...' and familiarize with the UI. You can assign each and every write-enabled property to a package variable.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

aveerabadran Ten Centuries Points: 1271 More actions · Answer 4

Thanks for ur reply CozyRoc.

I know we can very well use variables in send mail task . But my requirement is to use custom components as far as possible.

to give you a major advantage of using "custom mail component" :

say i have 20 packages and i use "send mail task" . Say some change has to be done for some reason , i need to touch all 20 packages. But if i had a custom mail component , we need to change only in that component.

can someone provide me with the help links for it

-Arunvijay

COZYROC One Orange Chip Points: 28499 More actions · Answer 5

Have you seen Script Task Plus? It does provide ability to implement reusable scripts and include your own setup and configuration. It is a light-weight approach, which doesn't require you to build your own custom tasks. You may also check this Send Mail script using the Script Task Plus functionality.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

aveerabadran (11/17/2008)
if i use Send mail task , i need to manually put the smtp server,from & to address , mail subject,etc ..... These info are taken from table and assigned to variables , and used in the packages. So i believe that , passing these variables to a custom mail component will make me re-use this in all my packages.
-Arunvijay

If you have the smtp server, from & to address, mail subject, etc in tables, what changes would necessate touching multiple SSIS packages if there were to be a change?