Package.CreatorComputerName Property

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

Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntaxe

'Déclaration
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)

Valeur de propriété

A String that contains the name of the computer.

Exemple

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 =

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

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