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)
Syntax
'Declaration
Public Property CreationDate As DateTime
Get
Set
'Usage
Dim instance As Package
Dim value As DateTime
value = instance.CreationDate
instance.CreationDate = value
public DateTime CreationDate { get; set; }
public:
property DateTime CreationDate {
DateTime get ();
void set (DateTime value);
}
member CreationDate : DateTime with get, set
function get CreationDate () : DateTime
function set CreationDate (value : DateTime)
Property Value
Type: System.DateTime
The date and time that the package was created.
Remarks
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.
Examples
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\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
Sample Output:
Package creation date = 5/5/2003 5:46:00 PM
Creation Computer =
Creator Name =