Package.CreationDate Properti

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Mendapatkan atau mengatur tanggal dan waktu paket dibuat.

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

Nilai Properti

DateTime

Tanggal dan waktu paket dibuat.

Atribut

LocalizablePropertyCategoryAttribute LocalizablePropertyDescriptionAttribute

Contoh

Contoh berikut memuat paket dari folder Sampel, lalu mengambil informasi tentang paket, seperti CreationDate, CreatorComputerName, dan 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  

Contoh Output:

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

Creation Computer =

Creator Name =

Keterangan

DateTime adalah jenis data varian VT_DATE, yang merupakan jenis data Layanan Integrasi DT_Date. Nilai ini dapat ditimpa. Untuk informasi selengkapnya tentang VT_DATE dan DT_Date, lihat Jenis Data Integration Services.