SSIS :Sending emails

hi experts


I have created SSIS packages that transfers excel file to database.Now i want to do some event handling .My question is

I want to send email with full details where task failed (i want to send whole result) and does not want to send mails if the package execution is success.How to do this.

Need step by step process please
sqlcuriousAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
fengqConnect With a Mentor Commented:
first, you need to setup email using SMTP server
http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

second, create an operator
http://technet.microsoft.com/en-us/library/ms175962.aspx
third,you can configure your SSIS task failure to send to that operator
0
 
sqlcuriousAuthor Commented:
Thanks for your reply

how can i do using event handler in SSIS ? dont have permission to configure database mail server in my system
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.