SSIS package - Task failure

  • Hi,

    I configured a SQL job for SSIS package consists of different SQL tasks and other import tasks.

    Some SQL tasks with in SSIS package are failing but the scheduled SQL job is getting succeeded with out any error.

    But from job history i can able to find the task failure information.

    Please advice me how to make the job failure if any of sub tasks inside SSIS package is going to fail.

    BR,

    Parthi

  • Did you write the SSIS package? The package could be ignoring the error for a number of reasons. It could be set up to execute the next task on completion of the previous task, there could have been OnError event handlers set up to not propogate the error.

    Have you looked into the package to see what it is doing?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • Hi John,

    Thanks for pointing the possibility of ignoring the error.

    I did nt include any error event handler in this package.

    I will learn more about this, and should i include all the steps(sub tasks) as same like that of control flow, dataflow to alert or ignore any error.

    BR,

    Parthi

  • Parthipan (8/9/2009)


    Hi John,

    I will learn more about this, and should i include all the steps(sub tasks) as same like that of control flow, dataflow to alert or ignore any error.

    BR,

    Parthi

    I'm not sure I'm following you here. Is this a question for me?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • Hi John,

    Sorry for the confusion..

    I am learning on how to create error event handler in SSIS package.

    Thanks for your support.

    BR,

    Parthi

  • Make sure in the Job step advanced properties you have set the 'On Failure quit the Job reporting failure' option.

    Regards

    Amol

    Amol Naik

Viewing 6 posts - 1 through 5 (of 5 total)

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