Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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
public enum DTSCheckpointUsage
public enum DTSCheckpointUsage
Member nameDescription
AlwaysSpecifies that the package always restarts.
IfExistsSpecifies that the package restarts if the file specified by the CheckpointFileName is found.
NeverSpecifies that the package never restarts. This is the default value.

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\90\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", null);

            // Set the CheckpointUsage to IfExistts to force package to retart 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

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.