SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Checkpoints with Transactions...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

malachi151
Posting Yak Master

148 Posts

Posted - 11/27/2012 :  14:31:55  Show Profile  Visit malachi151's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
2869 Posts

Posted - 11/27/2012 :  14:42:31  Show Profile  Reply with Quote
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.

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

malachi151
Posting Yak Master

148 Posts

Posted - 11/27/2012 :  14:57:23  Show Profile  Visit malachi151's Homepage  Reply with Quote
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
Go to Top of Page

malachi151
Posting Yak Master

148 Posts

Posted - 11/28/2012 :  09:06:53  Show Profile  Visit malachi151's Homepage  Reply with Quote
By the way, does anyone know if this functionality has been improved in 2012?

--------------------------------------------------
My blog: http://practicaltsql.net/
Twitter: @RGPSoftware
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000