Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Checkpoints in SSIS Expand / Collapse
Author
Message
Posted Wednesday, January 7, 2009 7:28 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:00 AM
Points: 912, Visits: 208
Comments posted to this topic are about the item Checkpoints in SSIS






My Blog: http://dineshasanka.spaces.live.com/
Post #631448
Posted Wednesday, January 14, 2009 2:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, January 14, 2009 8:35 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 10:52 AM
Points: 16, Visits: 125
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


Cheers,

Sean
Post #636288
Posted Wednesday, January 14, 2009 9:11 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,300, Visits: 1,378
Nice one...


Post #636352
Posted Wednesday, January 14, 2009 10:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Wednesday, January 14, 2009 12:35 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, March 16, 2014 10:26 AM
Points: 536, Visits: 516
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
Posted Wednesday, January 14, 2009 12:38 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, March 16, 2014 10:26 AM
Points: 536, Visits: 516
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 »

Add to briefcase

Permissions Expand / Collapse