Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DTSCheckpointUsage Enumeration
Collapse the table of content
Expand the table of content

DTSCheckpointUsage Enumeration

Specifies values that describe if, or when, a package is restarted.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public enum DTSCheckpointUsage

Member nameDescription
NeverSpecifies that the package never restarts. This is the default value.
IfExistsSpecifies that the package restarts if the file specified by the CheckpointFileName is found.
AlwaysSpecifies that the package always restarts.

The following code example sets the CheckpointUsage property.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace Package_API
{
    class Program
    {
        static void Main(string[] args)
        {
                    Application app = new Application();
            Package pkg = new Package();
            pkg = app.LoadPackage(@"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", null);

            // Set the CheckpointUsage to IfExists to force package to restart if
            // the file specified by the CheckpointFileName property is found.
            pkg.CheckpointUsage = DTSCheckpointUsage.IfExists;

            Console.WriteLine("Check for existing checkpoint file? {0}", pkg.CheckpointUsage);
        }
    }
}

Sample Output:

Check for existing checkpoint file? IfExists

Community Additions

ADD
Show:
© 2015 Microsoft