Post reply

Rollback Transactin Within a DTS Package

  • November 12, 2002 at 11:43 am

    #101306

    I have a DTS Package that truncates 2 tables and then imports data from 2 separate tables into the truncated tables.

    My problem, if either import fails I want both tables to go back to the way they were prior to being trucated. Now I thought this could be controlled within the DTS Package Properties, but it doesn't seem to be working.

    Any help would be great.

    Thanks

  • November 12, 2002 at 3:11 pm

    #441189

    Sorry Truncating tables does not allow for direct recovery. The thing I would do is create permament temp tables, move your data to those, truncate the main tables, run your next process, on fail move the data back to the main tables, on success truncate the permanent temp tables you put them in.

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

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