When connecting to a remote server on behalf of a client, Component Integration Services uses Client-Library functions. Once the first connection to a remote server is established for a given client, that connection remains open until the client disconnects from Component Integration Services.
For servers of class ASA, ASE, ASIQ, direct_connect (access_server) and sql_server (version 10.0 and later), only one connection is established to that server for each client that requires access to that server. All interaction with these servers is done with this single connection context.
However, for SQL Server versions earlier than 10.0, and servers of class db2, you may need to establish more than one connection to that server to process a single client request. In this case, multiple connections are established as needed, and all but one are closed when the Transact-SQL command requiring them has completed.
