Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hernan93
Starting Member
3 Posts |
 Posted - 2006-12-04 : 12:10:25
|
| 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? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-12-04 : 19:57:39
|
| Interesting - I doubted that anyone would find a useful apllication for checkpoints.I still say it's better (and simple) to add code to implement it yourself.There are a lot of odd things about the way it is implemented (especially to do with parallel tasks) - all I can suggest is that you test whatever you try to implement and look for the strange behaviour.Had someone at a company I am working at now who spent a lot of time trying to find a reason to use checkpointing and eventually gave up. Think it's a feature looking for a problem.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
ssis checkpoints