This documentation is archived and is not being maintained.

Package.CreationDate Property

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

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

public DateTime CreationDate { get; set; }
/** @property */
public DateTime get_CreationDate ()

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

public function get CreationDate () : DateTime

public function set CreationDate (value : DateTime)

Property Value

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 Data Types.


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

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.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Show: