reset failed status in SSIS

Discussion in 'microsoft.public.sqlserver.dts' started by Joe Sampino, Jun 17, 2010.

  1. Joe Sampino

    Joe Sampino Guest

    Hi all,

    i hope this is an easy question...
    i have an SSIS package that tries to do step A. if that fails, we have it
    set to on-failure do step B.

    this works fine except for the fact that the package returns a failed status
    even though step B ran correctly.

    is there any way to change the status of the package to remove the failure
    if step A fails? that way we only see it as failed if Steps A and B both fail.

    thanks,

    --Joe
     
    Joe Sampino, Jun 17, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.