Post reply

Set the flag in a table based on package success or failure

  • June 7, 2016 at 3:35 pm

    #308337

    how do we Set the flag in a table based on package success or failure ?

    I have entire logic in sequence container, if the pacakge fails need to set the flag to 0 or 1 in table

  • June 7, 2016 at 3:45 pm

    #1883744

    If you want True package completion message you would have to enable a logging provider at the package level...or depends on how you are calling the package.

    Alternative would be add execute sql task and use condition logic on the container to write either successful or failure record to hour table.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • June 8, 2016 at 1:30 am

    #1883802

    Or you could use event handlers.

    Jez

  • June 8, 2016 at 10:17 am

    #1883928

    Like Jez, my initial thought was a package level event handler.

    If you are running the package as an SSIS step in a job within SQL Server, you could also look for successful completion of the job step in MSDB.dbo.SysJobHistory.

Viewing 4 posts - 1 through 3 (of 3 total)

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