Post reply

Checkpoint file is not updated

  • February 6, 2010 at 3:48 am

    #138583

    Hi,

    I really need some help in SSIS checkpoints.

    I created a package programmatically and added checkpoint file configuration:

    pkg.SaveCheckpoints = true;

    pkg.CheckpointUsage = DTSCheckpointUsage.IfExists;

    pkg.CheckpointFileName = @"D:\TestDynamicPackage.txt";

    In all tasks I set the FailPackageOnFailure property to true.

    The package is created fine but when I execute it, the checkpoint file is created but it is not updated - remains 0kb also in case of failure.

    Please assist

    Thanks,

    Liron

  • February 8, 2010 at 12:50 am

    #1115314

    Looks like you set all the necessary properties correct. Have you checked your package in BIDS? Can you upload your package so we can have a look at it?

    Regards,

    Willem
    http://wschampheleer.wordpress.com[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply