Post reply

rollback ssis

  • January 21, 2019 at 3:52 am

    #381251

    Hello all,happy new year 2019
    In my SSIS job, I transfer files from one folder to another after processing to Stagging table in a ForEachLoop containerIs
    it possible to perform, in case of error in the job, a rollback that would put the processed files back in the original folder?

  • January 21, 2019 at 6:32 am

    #2019509

    There's no "undo" switch, but you can create a task that moves the files back, similar to the task that moved them in the first place.

    John

  • January 22, 2019 at 5:31 am

    #2019617

    abdalah.mehdoini - Monday, January 21, 2019 3:52 AM

    Hello all,happy new year 2019
    In my SSIS job, I transfer files from one folder to another after processing to Stagging table in a ForEachLoop containerIs
    it possible to perform, in case of error in the job, a rollback that would put the processed files back in the original folder?

    I'd suggest moving them to an Error folder instead, otherwise (if the files are problematic) the job will just keep failing repeatedly.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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