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 6:21 am

    #1631171

    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?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/