Home Forums Data Warehousing Integration Services Is it possible to Rollback the Transaction for a single load is you SSIS Package or the Job that runs the package? RE: Is it possible to Rollback the Transaction for a single load is you SSIS Package or the Job that runs the package?

  • July 10, 2013 at 1:42 pm

    #1631381

    Welsh Corgi (7/10/2013)

    For instance I have a job that basically stops loading records. If I kill it it messes up the data if I do not let it finish because of the way that the code in the package was written.

    This job was executing the 5th step from 5:00 AM until I finally killed it 12 hours later.

    I doubt that there is a way to roll back if I stop the job?

    You'd have to incorporate such logic in the packages itself.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP