Package.CreatorComputerName Property

Статья
12/15/2008

Gets or sets the name of the computer on which the package was created.

Пространство имен: Microsoft.SqlServer.Dts.Runtime
Сборка: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Синтаксис

'Декларация
Public Property CreatorComputerName As String

public string CreatorComputerName { get; set; }

public:
property String^ CreatorComputerName {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_CreatorComputerName ()

/** @property */
public void set_CreatorComputerName (String value)

public function get CreatorComputerName () : String

public function set CreatorComputerName (value : String)

Значение свойства

A String that contains the name of the computer.

Пример

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.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

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

Поделиться через