Package.CreatorName 속성

정의

네임스페이스:

Microsoft.SqlServer.Dts.Runtime

어셈블리:

Microsoft.SqlServer.ManagedDTS.dll

패키지를 만든 개별 사용자의 이름을 가져오거나 설정합니다.

public:
 property System::String ^ CreatorName { System::String ^ get(); void set(System::String ^ 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), "CreatorNameDesc")]
public string CreatorName { 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), "CreatorNameDesc")>]
member this.CreatorName : string with get, set

Public Property CreatorName As String

속성 값

String

패키지를 만든 개별 사용자의 이름입니다.

특성

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 =