Package.CreationDate プロパティ

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

プロパティ値

パッケージが作成された日付と時間。

属性

LocalizablePropertyCategoryAttribute LocalizablePropertyDescriptionAttribute

例

以下の例では、Samplesフォルダからパッケージを読み込み、そのパッケージの CreationDate、 CreatorComputerName、 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  

出力例:

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

Creation Computer =

Creator Name =

注釈

DateTimeはVT_DATEのバリアントデータ型であり、統合サービスのデータ型DT_Dateです。 この値は上書きされることがあります。 VT_DATEおよびDT_Dateの詳細については、 統合サービスデータタイプをご覧ください。