Export (0) Print
Expand All

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)

public string UserName { get; }

Property Value

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

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...

Community Additions

ADD
Show:
© 2014 Microsoft