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.

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

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