SSIS 2008 and how to get notified if email server is down.
Hi,
I have an SSIS package in which the tasks are:
1. TASK 1: log to a file that the package started.
2. TASK 2: email task
3. TASK 3: EXECUTE SQL TASK
4. TASK 4: email a report
Problem is if the email server gateway is down, then TASK 2 fails. However, I want TASK 3 to run regardless and I can do this by creating a Precedent Constraint arrow from TASK 1 to TASK 3. Problem is how would I be notified that the email server is down so that when the email is working again, that I'd know when I can run TASK 4 (a report)?
Thanks.
I have an SSIS package in which the tasks are:
1. TASK 1: log to a file that the package started.
2. TASK 2: email task
3. TASK 3: EXECUTE SQL TASK
4. TASK 4: email a report
Problem is if the email server gateway is down, then TASK 2 fails. However, I want TASK 3 to run regardless and I can do this by creating a Precedent Constraint arrow from TASK 1 to TASK 3. Problem is how would I be notified that the email server is down so that when the email is working again, that I'd know when I can run TASK 4 (a report)?
Thanks.
David Johnson, CD
you have to (a) have a method of detecting if the mail server is down and (b) have an alternate way of informing you of this i.e. SMS
>> Problem is if the email server gateway is down, then TASK 2 fails. However, I want TASK 3 to run regardless and I can do this by creating a Precedent Constraint arrow from TASK 1 to TASK 3.
If you want to continue from TASK 1 to TASK 3, then just modify your Second TASK to write entry to a SQL table, continue with TASK 3 and then try to send an Email as part of TASK 4. This way you will have a record stored in the SQL Table even though your email server fails.
If you want to continue from TASK 1 to TASK 3, then just modify your Second TASK to write entry to a SQL table, continue with TASK 3 and then try to send an Email as part of TASK 4. This way you will have a record stored in the SQL Table even though your email server fails.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I wanted a notification as opposed to a log file.