Package.CreationDate Property

Gets or sets the date and time that the package was created.

命名空间: Microsoft.SqlServer.Dts.Runtime
程序集: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

语法

声明
Public Property CreationDate As DateTime

public DateTime CreationDate { get; set; }

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

/** @property */
public DateTime get_CreationDate ()

/** @property */
public void set_CreationDate (DateTime value)

public function get CreationDate () : DateTime

public function set CreationDate (value : DateTime)

属性值

A DateTime object.

备注

The DateTime is a variant data type VT_DATE, which is a Integration Services data type of DT_Date. This value can be overwritten. For more information about VT_DATE and DT_Date, see Integration Services 数据类型.

示例

The following example loads a package from the Samples folder, and then retrieves information about the package, such as its CreationDate, CreatorComputerName, and 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\90\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\90\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

Sample Output:

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

Creation Computer =

Creator Name =

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

Package Class
Package Members
Microsoft.SqlServer.Dts.Runtime Namespace