Nuta
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować się zalogować lub zmienić katalog.
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować zmienić katalogi.
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, @"")