Post reply

OnPostExecute & OnError Execute

  • October 27, 2008 at 8:02 am

    #126559

    I am creating two trigger files a Success trigger file and a failure trigger file,The Failure Trigger file get created onError Event Handler the success trigger file gets created onPostExecute.But when ithere is an error in the execution on the package, I am seeing both the trigger file gets generated. Do the OnpostExecute event will get triggered after the onError Event.Is there any way i can stop without the execution of OnpostExecute Event(Creation of success trigger) when there is an error.

  • October 28, 2008 at 6:56 am

    #890582

    Handle OnError event and store if there is an error in a boolean package variable. Let's say TaskFailedVar. When your work flow arrives in your OnPostExecute logic, you will know if there was an error by checking TaskFailedVar variable state.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply