The Connection object contains information about connections to data sources through OLE DB service providers. Connection objects allow connection pooling and reuse for connections within a package so that only one connection must be established for multiple steps or tasks.
The Connection object is compatible with Microsoft® SQL Server™ version 7.0. For more information about an extended version of this object, see Connection2 Object