Share via


RunningPackage.UserName Property

Returns the user name used to log on to the server.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

'Declaration
Public ReadOnly Property UserName As String 
    Get
'Usage
Dim instance As RunningPackage 
Dim value As String 

value = instance.UserName
public string UserName { get; }
public:
property String^ UserName {
    String^ get ();
}
member UserName : string
function get UserName () : String

Property Value

Type: System.String
A String that contains a user name.

Examples

The following example shows how to retrieve the collection of running packages from the Application object and iterate over each package, displaying the InstanceID, PackageID, PackageDescription, PackageName, and 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...

See Also

Reference

RunningPackage Class

Microsoft.SqlServer.Dts.Runtime Namespace