Checkpoints in SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Dinesh Asanka » Checkpoints in SSIS

Checkpoints in SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

Dinesh Asanka

Posted Wednesday, January 07, 2009 7:28 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:30 PM
Points: 912, Visits: 198

Comments posted to this topic are about the item Checkpoints in SSIS

My Blog: http://dineshasanka.spaces.live.com/

Post #631448

Graham Lee-348559

Posted Wednesday, January 14, 2009 2:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 14, 2010 8:31 AM
Points: 4, Visits: 34

Hi,
I have a specific checkpoint problem.

Occasionally, the SSIS package that I have scheduled will run through successfully to completion, but will not delete the checkpoint file at the end. The checkpoint file itself will have success indicators for every step in the package. Therefore the next time the package runs, it will do nothing.

This is an intermittent problem. Have you come across this before?

Thanks,
Graham

Post #636064

Sean Woehrle

Posted Wednesday, January 14, 2009 8:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 6:24 AM
Points: 7, Visits: 77

Nice article.
I think you meant, step A will not be run in one of your last paragraphs.

The article has
Execution time will be saved..."As it does not run the failed step"

Thanks,
Sean

Post #636288

Anipaul

Posted Wednesday, January 14, 2009 9:11 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,815, Visits: 1,343

Nice one...

Post #636352

G-451588

Posted Wednesday, January 14, 2009 10:19 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, December 22, 2011 10:27 AM
Points: 59, Visits: 193

Thanks for such a clear, concise explanation of this topic. (BTW, I've never rated an article before, so accidentally hit 1 star instead of 5. Sorry, I didn't realize it was a one-click operation. I'll know better next time!)

Post #636432

vishal.gamji

Posted Wednesday, January 14, 2009 12:35 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 13, 2013 1:17 PM
Points: 536, Visits: 482

What would be the impact of taking snapshots on evry step? i.e. if you data warehouse\db is very large? I guess i would have to include a some logic to delete the older snapshots after every step ... right?

Post #636560

vishal.gamji

Posted Wednesday, January 14, 2009 12:38 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 13, 2013 1:17 PM
Points: 536, Visits: 482

Addition to prev post:
What would be the impact of taking snapshots on evry step? i.e. if you data warehouse\db is very large? I guess i would have to include a some logic to delete the older snapshots after every step ... right? So that, only the changes are propagated on each run of the ETL.

Post #636565

« Prev Topic | Next Topic »

Permissions