Propriedade do RDL ChunkSize
Gets or sets the value that indicates the minimum number of bytes to retrieve from or send to the server during a read/write operation.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (em Microsoft.SqlServer.ManagedDTS.dll)
Sintaxe
'Declaração
Public Property ChunkSize As Integer
Get
Set
'Uso
Dim instance As HttpClientConnection
Dim value As Integer
value = instance.ChunkSize
instance.ChunkSize = value
public int ChunkSize { get; set; }
public:
property int ChunkSize {
int get ();
void set (int value);
}
member ChunkSize : int with get, set
function get ChunkSize () : int
function set ChunkSize (value : int)
Valor da propriedade
Tipo: System. . :: . .Int32
An Integer that contains the minimum number of bytes to retrieve or send.
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"