SQL Server Performance

checkpoint and transactions.

Discussion in 'SQL Server 2005 Integration Services' started by hernan93, Dec 4, 2006.

  1. hernan93 Member

    I have a package that uses ssis checkpoints. It works well. However, when I try to setup transactions for some task, the chekpoints aren't used.

    I read BOL and It states:
    "If a package is configured to use checkpoints, Integration Services captures the restart point in the checkpoint file. The type of container that fails and the implementation of features such as transactions affect the restart point that is recorded in the checkpoint file."

    But, how checkpoints are affected by transactions? what relation exists between this two components?
  2. satya Moderator

    You configure Integration Services packages to restart from a point of failure, instead of rerunning the entire package, by setting the properties that apply to checkpoints and ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/48f2fbb7-8964-484a-8311-5126cf594bfb.htm (BOL) link fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page