Compartir a través de


Password Propiedad

Sets the password for the connection, if you do not use Windows Authentication.

Espacio de nombres:  Microsoft.SqlServer.Dts.ManagedConnections
Ensamblado:  Microsoft.SqlServer.ManagedConnections (en Microsoft.SqlServer.ManagedConnections.dll)

Sintaxis

'Declaración
Public WriteOnly Property Password As String
    Set
'Uso
Dim instance As WMIConn
Dim value As String

instance.Password = value
public string Password { set; }
public:
property String^ Password {
    void set (String^ value);
}
member Password : string with get, set
function set Password (value : String)

Valor de la propiedad

Tipo: System. . :: . .String
A String that contains the password for the connection.

Comentarios

If you do not use Windows Authentication, you must provide the password for the connection.

Ejemplos

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, @"")