• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

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
0
sqlcurious
Asked:
sqlcurious
1 Solution
 
fengqCommented:
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now