Explain how you can notify the staff members about package failure?

Either inside the package you could add a Send Mail Task in the event handlers, or you can even set notification in the SQL Agent when the package runs.

Be the first to comment

Leave a Reply

Your email address will not be published.