Remarque
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de vous connecter ou de modifier des répertoires.
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de modifier des répertoires.
Gets or sets the user name for the connection, if you do not use Windows Authentication.
Espace de noms : Microsoft.SqlServer.Dts.ManagedConnections
Assembly : Microsoft.SqlServer.ManagedConnections (en Microsoft.SqlServer.ManagedConnections.dll)
Syntaxe
'Déclaration
Public Property UserName As String
Get
Set
'Utilisation
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)
Valeur de propriété
Type : System.String
A String that contains the user name for the connection.
Notes
If you do not use Windows Authentication, you must provide a user name and password for the connection.
Exemples
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, @"")