Professional
« Analyzing SQL Server Performance: MDW | Main | Optimize Oracle with CLUSTER's and Index Organized Tables »
Tuesday
May032011

Reporting on Exchange NDR/Undeliverable E-mails

Recently I was asked to report on the non-deliverable (bounceback) e-mails we were sending from an internal mailbox.  I put together a Powershell script that grabbed the information from Exchange (version 2007 or above) then imported it into a SQL Server database using SSIS.

In my first post of this series I'll be going over the Powershell script to get e-mails out of the Exchange system then will be posting one of my first (and more exciting) attempts at an ETL solution using SSIS.

Check out the Bounceback Project heading under SQL on the right.

Stay tuned!

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>