checkpoint and transactions. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

checkpoint and transactions.

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?
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.
]]>