Package.CreationDate Propriété

Définition

Espace de noms:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Obtient ou définit la date et l'heure de création du package.

public:
 property DateTime CreationDate { DateTime get(); void set(DateTime value); };

[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryIdentification")]
[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "CreationDateDesc")]
public DateTime CreationDate { get; set; }

[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryIdentification")>]
[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "CreationDateDesc")>]
member this.CreationDate : DateTime with get, set

Public Property CreationDate As DateTime

Valeur de propriété

DateTime

Date et heure de création du package.

Attributs

LocalizablePropertyCategoryAttribute LocalizablePropertyDescriptionAttribute

Exemples

L’exemple suivant charge un package à partir du dossier Samples, puis récupère des informations sur le package, telles que son CreationDate, CreatorComputerNameet CreatorName.

static void Main(string[] args)  
        {  
            // The variable pkg points to the location  
            // of the ExecuteProcess package sample   
            // that is installed with the samples.  
            string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";  

            Application app = new Application();  
            Package p = app.LoadPackage(pkg, null);  

            //Retrieve creation information about the package.  
            DateTime createDate = p.CreationDate;  
            String computerCreated = p.CreatorComputerName;  
            String creatorName = p.CreatorName;  

            Console.WriteLine("Package creation date = " + createDate);  
            Console.WriteLine("Creation Computer = " + computerCreated);  
            Console.WriteLine("Creator Name = " + creatorName);  
        }  

Shared  Sub Main(ByVal args() As String)  
            ' The variable pkg points to the location  
            ' of the ExecuteProcess package sample   
            ' that is installed with the samples.  
            Dim pkg As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"   

            Dim app As Application =  New Application()   
            Dim p As Package =  app.LoadPackage(pkg,Nothing)   

            'Retrieve creation information about the package.  
            Dim createDate As DateTime =  p.CreationDate   
            Dim computerCreated As String =  p.CreatorComputerName   
            Dim creatorName As String =  p.CreatorName   

            Console.WriteLine("Package creation date = " + createDate)  
            Console.WriteLine("Creation Computer = " + computerCreated)  
            Console.WriteLine("Creator Name = " + creatorName)  
End Sub  

Exemple de sortie :

Package creation date = 5/5/2003 5:46:00 PM

Creation Computer =

Creator Name =

Remarques

DateTime est un type de données variant VT_DATE, qui est un type de données Integration Services de DT_Date. Cette valeur peut être remplacée. Pour plus d’informations sur les VT_DATE et les DT_Date, consultez Types de données Integration Services.