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 |
|
malachi151
Posting Yak Master
152 Posts |
 Posted - 2012-11-27 : 14:31:55
|
| I am using SQL Server 2008, not R2.I'm creating an SSIS package, and I've properly enabled checkpoints.I'm using sequence containers with transactions.When I enable the transactions on the sequence containers (TransactionOption: Required) the checkpoint files no longer work.The checkpoint file will get created when there is a failure, but its an empty file with no actual checkpoint in it.I also tried using a ForLoop as described here: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65809/This does work as described when not using transactions, but again when I turn on transactions then upon a failure I get an empty checkpoint file.Any ideas? Seems like kind of a major bug, I can't imagine that it isn't possible to use checkpoints and transactions.Is this something that has been resolved in a later release or something?--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2012-11-27 : 14:42:31
|
| I have no advice, but we ran into the same problem here. I'm not an SSIS guy, but our SSIS team stopped using the checkpoints in SSIS and programmed their own -- a stored procedure that fires off before anything else in the container and checks things and then another that fires off after everything else that sets things.JimEveryday I learn something that somebody else already knew |
 |
|
|
malachi151
Posting Yak Master
152 Posts |
Posted - 2012-11-27 : 14:57:23
|
| Yeah, the biggest bummer with that is handling all the of the run-time variables....Seems like a massive shortfall....--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
|
|
|
malachi151
Posting Yak Master
152 Posts |
Posted - 2012-11-28 : 09:06:53
|
| By the way, does anyone know if this functionality has been improved in 2012?--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |
|
|
|
|
|
|
Checkpoints with Transactions...