Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Create custom error log Expand / Collapse
Author
Message
Posted Sunday, May 4, 2014 8:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 13, 2014 11:15 PM
Points: 3, Visits: 30
Hi All,

I am new to ssis ,i want to send customized email notification in the below scenario

i am uploading an excel generic file data to table table say table1 ,while in the ETL process one unique key will generate with combination columns (columns1+column2+ column 3)

Now if some data missed in the any of columns (columns1+column2+ column 3) ,unique key will not generate ,that means these are mandatory fields ,so while uploading file if data is missed we need send an email to users say "particular column values are not updated" like that

Can anybody please help me for solving this issue .



Post #1567336
Posted Monday, May 5, 2014 7:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:20 AM
Points: 42, Visits: 265
I use an Exec SQL task. Create a data source that connects to msdb and use the system stored procedure dbo.sp_send_dbmail

Here is the TechNet article describing it:
http://technet.microsoft.com/en-us/library/ms190307.aspx
Post #1567500
Posted Monday, May 5, 2014 2:29 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 300, Visits: 810
your title says logging. after you send the email, no bother to insert a row into a table you create for the purpose of capturing things like this. That would fit the definition of custom logging.

Post #1567707
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse