Solved

SSIS :Sending emails

Posted on 2011-03-25
2
403 Views
Last Modified: 2012-05-11
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
Comment
Question by:sqlcurious
2 Comments
 
LVL 1

Accepted Solution

by:
fengq earned 500 total points
ID: 35218355
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
 

Author Comment

by:sqlcurious
ID: 35218528
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question