RunningPackage.UserName Property

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

命名空間: Microsoft.SqlServer.Dts.Runtime
組件: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

語法

'宣告
Public ReadOnly Property UserName As String

public string UserName { get; }

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

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

public function get UserName () : 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...

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

執行緒安全性

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.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

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