Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Integration Services (SSIS), Email Rss

   Items 1 to 4 of 4   
 

Setting Up Email Notification for SSIS Package Failure

As a DBA, we often setup monitoring to receive job failure notification, but when it comes to SSIS packages, we either do not capture the job failure (if the job runs through the command prompt) or we have no idea why it failed. In this article, I'd like to walk you through how to enable the logging functionality for SQL Server Integration Services (SSIS) and how to capture detailed information for immediate troubleshooting without "re-run" the package.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,313 reads

Sending scheduled SQL query results via HTML e-mail using SSIS

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...
By Paul Clancy 2010/09/03 (first published: 2008/04/23) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 52,685 reads

Sending scheduled SQL query results via HTML e-mail using SSIS

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...
By Paul Clancy 2010/09/03 (first published: 2008/04/23) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 52,685 reads

Sending scheduled SQL query results via HTML e-mail using SSIS

Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.  Read more...
By Paul Clancy 2010/09/03 (first published: 2008/04/23) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 52,685 reads
   Items 1 to 4 of 4   
 
Tags
sql xml (1)    
xml (1)    
xsl (1)