Post reply

SSIS package - Task failure

  • August 6, 2009 at 2:34 am

    #133703

    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

  • August 6, 2009 at 9:26 am

    #1035461

    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

  • August 9, 2009 at 1:57 am

    #1036458

    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

  • August 10, 2009 at 10:13 am

    #1036882

    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

  • August 10, 2009 at 11:31 pm

    #1037234

    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

  • August 11, 2009 at 11:18 am

    #1037614

    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