RunningPackage.UserName Propiedad

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Runtime

Ensamblado:

Microsoft.SqlServer.ManagedDTS.dll

Devuelve el nombre de usuario que se utiliza para iniciar sesión en el servidor.

public:
 property System::String ^ UserName { System::String ^ get(); };

public string UserName { get; }

member this.UserName : string

Public ReadOnly Property UserName As String

Valor de propiedad

String

Cadena que contiene un nombre de usuario.

Ejemplos

En el ejemplo siguiente se muestra cómo recuperar la colección de paquetes en ejecución del Application objeto e iterar en cada paquete, mostrando los InstanceIDvalores , PackageID, PackageDescription, PackageNamey UserName.

static void Main(string[] args)  
        {  
            Application app = new Application();  
            // Create a RunningPackages collection, pkgs, and fill it  
            // with the running packages from the application object.  
            RunningPackages pkgs = app.GetRunningPackages("yourserver");  
            // Enumerate over each package in the collection and  
            // display some properties.  
            foreach (RunningPackage p in pkgs)  
            {  
                Console.WriteLine("InstanceID: " + p.InstanceID);  
                Console.WriteLine("PackageDescription: " + p.PackageDescription);  
                Console.WriteLine("PackageID: " + p.PackageID);  
                Console.WriteLine("PackageName: " + p.PackageName);  
                Console.WriteLine("UserName: " + p.UserName);  
            }  
//   more code here...  

static void Main(string() args)  
        {  
            Dim app As Application =  New Application()   
            ' Create a RunningPackages collection, pkgs, and fill it  
            ' with the running packages from the application object.  
            Dim pkgs As RunningPackages =  app.GetRunningPackages("yourserver")   
            ' Enumerate over each package in the collection and  
            ' display some properties.  
            Dim p As RunningPackage  
            For Each p In pkgs  
                Console.WriteLine("InstanceID: " + p.InstanceID)  
                Console.WriteLine("PackageDescription: " + p.PackageDescription)  
                Console.WriteLine("PackageID: " + p.PackageID)  
                Console.WriteLine("PackageName: " + p.PackageName)  
                Console.WriteLine("UserName: " + p.UserName)  
            Next  
'   more code here...