Partilhar via

  • Artigo

Propriedade do RDL ServerPassword

Sets the password used to log on to the server. This property is write-only.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (em Microsoft.SqlServer.ManagedDTS.dll)

Sintaxe

'Declaração
Public WriteOnly Property ServerPassword As String
    Set
'Uso
Dim instance As HttpClientConnection
Dim value As String

instance.ServerPassword = value

public string ServerPassword { set; }

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

member ServerPassword : string with get, set

function set ServerPassword (value : String)

Valor da propriedade

Tipo: System. . :: . .String

Comentários

This property applies only if you are using credentials.

Exemplos

The following code example creates an HttpClientConnection, then sets the properties. The value of the properties require replacment with values that are valid for your application.

string[] byPassList = { "http://myserver", "http://companysite" };
Package pkg = new Package();
ConnectionManager httpConn = pkg.Connections.Add("HTTP");
HttpClientConnection clientConn = new HttpClientConnection(httpConn.AcquireConnection(null));
clientConn.ChunkSize = 5;  // Default is 1.
clientConn.ProxyBypassList = byPassList;
clientConn.Timeout = 60;  // Default is 30.
clientConn.UseSecureConnection = false;

// When UseServerCredentials is true, provide Domain and Password.
clientConn.UseServerCredentials = true;
clientConn.ServerDomain = "serverLogOnDomain";
clientConn.ServerUserName = "serversUserName";
clientConn.ServerPassword = "serverPasswd"; // Write-only property.

// When UseProxyCredentials is true, provide Domain and Password.
clientConn.UseProxyCredentials = true;
clientConn.ProxyDomain = "myDomain";
clientConn.ProxyPassword = "proxyPassword";

Dim byPassList() As String = {"http://myserver", "http://companysite"}

Dim pkg As Package =  New Package() 
Dim httpConn As ConnectionManager =  pkg.Connections.Add("HTTP") 
Dim clientConn As HttpClientConnection =  New HttpClientConnection(httpConn.AcquireConnection(Nothing)) 
clientConn.ChunkSize = 5  ' Default is 1.
clientConn.ProxyBypassList = byPassList
clientConn.Timeout = 60  ' Default is 30.
clientConn.UseSecureConnection = False
 
' When UseServerCredentials is true, provide Domain and Password.
clientConn.UseServerCredentials = True
clientConn.ServerDomain = "serverLogOnDomain"
clientConn.ServerUserName = "serversUserName"
clientConn.ServerPassword = "serverPasswd" ' Write-only property.
 
' When UseProxyCredentials is true, provide Domain and Password.
clientConn.UseProxyCredentials = True
clientConn.ProxyDomain = "myDomain"
clientConn.ProxyPassword = "proxyPassword"