PackageInfo.CreationDate 속성

정의

네임스페이스:

Microsoft.SqlServer.Dts.Runtime

어셈블리:

Microsoft.SqlServer.ManagedDTS.dll

패키지를 만든 날짜 및 시간을 가져옵니다. 이 속성은 읽기 전용입니다.

public:
 property DateTime CreationDate { DateTime get(); };

public DateTime CreationDate { get; }

member this.CreationDate : DateTime

Public ReadOnly Property CreationDate As DateTime

속성 값

DateTime

패키지를 만든 날짜를 나타내는 DateTime 값입니다.

예제

다음 코드 예제에서는 샘플 패키지를 로드하고, 패키지를 서비스에 저장한 다음, 패키지를 검색하고 속성을 반복합니다.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace PackageInfoTest  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            //  The pkg variable points to a package  
            //  installed with the SSIS samples.  
            string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";  

            Application app = new Application();  
            Package p1 = app.LoadPackage(pkg, null);  
            p1.Description = "CalculatedColumns package";  

            app.SaveToDtsServer(p1, null, @"File System\myp1Package", "YOURSERVER");  
            PackageInfos pInfos = app.GetDtsServerPackageInfos(@"File System", "YOURSERVER");  
            foreach (PackageInfo pinfo in pInfos)  
            {  
                Console.WriteLine("Package Information");  
                Console.WriteLine("CreationDate:        {0}", pinfo.CreationDate);  
                Console.WriteLine("Description:         {0}", pinfo.Description);  
                Console.WriteLine("Flags:               {0}", pinfo.Flags);  
                Console.WriteLine("Folder:              {0}", pinfo.Folder);  
                Console.WriteLine("Name:                {0}", pinfo.Name);  
                Console.WriteLine("PackageDataSize:     {0}", pinfo.PackageDataSize);  
                Console.WriteLine("PackageGuid:         {0}", pinfo.PackageGuid);  
                Console.WriteLine("VersionBuild:        {0}", pinfo.VersionBuild);  
                Console.WriteLine("VersionComments      {0}", pinfo.VersionComments);  
                Console.WriteLine("VersionGUID          {0}", pinfo.VersionGUID);  
                Console.WriteLine("VersionMajor         {0}", pinfo.VersionMajor);  
                Console.WriteLine("VersionMinor         {0}", pinfo.VersionMinor);  
                Console.WriteLine();  
            }  
         }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace PackageInfoTest  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            '  The pkg variable points to a package  
            '  installed with the SSIS samples.  
            Dim pkg As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx"   

            Dim app As Application =  New Application()   
            Dim p1 As Package =  app.LoadPackage(pkg,Nothing)   
            p1.Description = "CalculatedColumns package"  

            app.SaveToDtsServer(p1, Nothing, "File System\myp1Package", "YOURSERVER")  
            Dim pInfos As PackageInfos =  app.GetDtsServerPackageInfos("File System","YOURSERVER")   
            Dim pinfo As PackageInfo  
            For Each pinfo In pInfos  
                Console.WriteLine("Package Information")  
                Console.WriteLine("CreationDate:        {0}", pinfo.CreationDate)  
                Console.WriteLine("Description:         {0}", pinfo.Description)  
                Console.WriteLine("Flags:               {0}", pinfo.Flags)  
                Console.WriteLine("Folder:              {0}", pinfo.Folder)  
                Console.WriteLine("Name:                {0}", pinfo.Name)  
                Console.WriteLine("PackageDataSize:     {0}", pinfo.PackageDataSize)  
                Console.WriteLine("PackageGuid:         {0}", pinfo.PackageGuid)  
                Console.WriteLine("VersionBuild:        {0}", pinfo.VersionBuild)  
                Console.WriteLine("VersionComments      {0}", pinfo.VersionComments)  
                Console.WriteLine("VersionGUID          {0}", pinfo.VersionGUID)  
                Console.WriteLine("VersionMajor         {0}", pinfo.VersionMajor)  
                Console.WriteLine("VersionMinor         {0}", pinfo.VersionMinor)  
                Console.WriteLine()  
            Next  
        End Sub  
    End Class  
End Namespace  

샘플 출력:

Package Information

CreationDate: 3/24/2008 5:21:51 PM

Description:

Flags: Package

Folder: File System

Name: myp1Package

PackageDataSize: 0

PackageGuid:

VersionBuild: 0

VersionComments

VersionGUID

VersionMajor 0

VersionMinor 0