共用方式為


WMIConn.UserName Property

Gets or sets the user name for the connection, if you do not use Windows Authentication.

命名空間: Microsoft.SqlServer.Dts.ManagedConnections
組件: Microsoft.SqlServer.ManagedConnections (in microsoft.sqlserver.managedconnections.dll)

語法

'宣告
Public Property UserName As String
public string UserName { get; set; }
public:
property String^ UserName {
    String^ get ();
    void set (String^ value);
}
/** @property */
public String get_UserName ()

/** @property */
public void set_UserName (String value)
public function get UserName () : String

public function set UserName (value : String)

屬性值

A String that contains the user name for the connection.

備註

If you do not use Windows Authentication, you must provide a user name and password for the connection.

範例

The following code example adds a WMI connection to a package, and sets the ServerName, UserName, and Password properties. The code example needs to be modified to have the appropriate values supplied for the properties for your application.

ConnectionManager WmiConn = pkg.Connections.Add("WMI");
DtsProperty prop = WmiConn.Properties["ServerName"];
prop.SetValue(WmiConn, @"\\localhost");
WmiConn.Properties["Username"].SetValue(WmiConn, @"");
WmiConn.Properties["Password"].SetValue(WmiConn, @"");
Dim WmiConn As ConnectionManager =  pkg.Connections.Add("WMI") 
Dim prop As DtsProperty =  WmiConn.Properties("ServerName") 
prop.SetValue(WmiConn, "\\localhost")
WmiConn.Properties("Username").SetValue(WmiConn, @"")
WmiConn.Properties("Password").SetValue(WmiConn, @"")

執行緒安全性

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 的硬體和軟體需求>。

請參閱

參考

WMIConn Class
WMIConn Members
Microsoft.SqlServer.Dts.ManagedConnections Namespace