Solved

SSIS :Sending emails

Posted on 2011-03-25
2
401 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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