I have a dts which I am using to copy a db from the production server to the
backup server. I used the "copy sql sever object task" to copy the db.
Initally I had a problem with the views because the system was trying to copy
a view that called another view that the system had not yet created. To get
around this I added an "Execute Sql task" which ran (after the copy sql
server object task failed)the sql to recreate the views in the correct order.
That all now works, but at the end of the process I set up 2 email
notifications one for failure and one for success. They never get executed.
Can anyone explain this?

thanks