Package.CheckpointUsage Propiedad

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Runtime

Ensamblado:

Microsoft.SqlServer.ManagedDTS.dll

Obtiene o establece un valor que especifica si un paquete se reinicia o cuándo se reinicia.

public:
 property Microsoft::SqlServer::Dts::Runtime::DTSCheckpointUsage CheckpointUsage { Microsoft::SqlServer::Dts::Runtime::DTSCheckpointUsage get(); void set(Microsoft::SqlServer::Dts::Runtime::DTSCheckpointUsage value); };

[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryCheckpoints")]
[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "CheckpointUsageDesc")]
public Microsoft.SqlServer.Dts.Runtime.DTSCheckpointUsage CheckpointUsage { get; set; }

[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryCheckpoints")>]
[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "CheckpointUsageDesc")>]
member this.CheckpointUsage : Microsoft.SqlServer.Dts.Runtime.DTSCheckpointUsage with get, set

Public Property CheckpointUsage As DTSCheckpointUsage

Valor de propiedad

DTSCheckpointUsage

Un valor de la enumeración DTSCheckpointUsage.

Atributos

LocalizablePropertyCategoryAttribute LocalizablePropertyDescriptionAttribute

Ejemplos

En el ejemplo de código siguiente se establece la CheckpointUsage propiedad .

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 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);  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace Package_API  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
                    Dim app As Application =  New Application()   
            Dim pkg As Package =  New Package()   
            pkg = app.LoadPackage("C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", Nothing)  

            ' 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)  
        End Sub  
    End Class  
End Namespace  

Salida del ejemplo:

Check for existing checkpoint file? IfExists

Comentarios

El valor predeterminado de esta propiedad es Never, que indica que el paquete no puede reiniciarse. Para obtener más información sobre el uso de puntos de control en un paquete, vea Reiniciar paquetes mediante puntos de control.