通过

  • 项目

UserName 属性

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

命名空间：  Microsoft.SqlServer.Dts.ManagedConnections
程序集：  Microsoft.SqlServer.ManagedConnections（在 Microsoft.SqlServer.ManagedConnections.dll 中）

语法

声明
Public Property UserName As String
    Get
    Set
用法
Dim instance As WMIConn
Dim value As String

value = instance.UserName

instance.UserName = value

public string UserName { get; set; }

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

member UserName : string with get, set

function get UserName () : String
function set UserName (value : String)

属性值

类型：System. . :: . .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, @"")