none
Exception has been thrown by the target of an invocation. RRS feed

  • Question

  • WE ARE USING SCRIPT TASK TO SEND A STATUS MAIL WITH ATTACHMENT.PROBLEM IS ITS WORKING FINE ON EVERYDAY, BUT ITS NOT WORKING ON SUNDAY AND EXCEPTION ITS THROWING AS "Exception has been thrown by the target of an invocation."THIS IS CONFIGURED IN SSIS . IN SERVER LEVEL THERE IS MAINTENANCE ACTIVITY AT THAT TIME.
    Friday, November 28, 2014 10:25 AM

Answers

  • How do you execute the "Send Status Mail" package?
    If SQL Agent, then which account is in use there?

    Maybe on Sunday, both package and Maintenance plan are active, resources needed by Package are denied because they are in use by Maintenance plan.

    Try considering your package execution prior/ahead of Maintenenace plan schedule


    -Vaibhav Chaudhari

    Friday, November 28, 2014 10:45 AM