Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Sets the password for the connection, if you do not use Windows Authentication.
Namespace: Microsoft.SqlServer.Dts.ManagedConnections
Assembly: Microsoft.SqlServer.ManagedConnections (in Microsoft.SqlServer.ManagedConnections.dll)
Syntax
'Declaration
Public WriteOnly Property Password As String
Set
'Usage
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)
Property Value
Type: System.String
A String that contains the password for the connection.
Remarks
If you do not use Windows Authentication, you must provide the password for the connection.
Examples
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, @"")