Configure OLE DB Connection Manager
Use the Configure OLE DB Connection Manager dialog box to add a connection to a data source, which can be either a new connection or a copy of an existing connection.
Note
To connect to a data source that uses Microsoft Office Excel 2003 or earlier, use an Excel connection manager. For more information, see Excel Connection Manager. To connect to a data source that uses Microsoft Office Excel 2007, use an OLE DB connection manager, and for Provider, select Microsoft Office 12.0 Access Database Engine OLE DB Provider. Then, on the All page of the Connection Manager dialog box, for Extended Properties, enter Excel 12.0. To load data from or to an Excel 2007 data source, use an OLE DB source or an OLE DB destination, respectively. You cannot use an Excel source or an Excel destination to load data from or to an Excel 2007 data source. To connect to a database that uses Microsoft Office Access 2003 or earlier, use an OLE DB connection manager, and then for Provider, select Microsoft Jet 4.0 OLE DB Provider. To connect to a database that uses Microsoft Office Access 2007, use an OLE DB connection manager, and then for Provider, select Microsoft Office 12.0 Access Database Engine OLE DB Provider. To connect to data sources that use Excel 2007 or Access 2007, you cannot select Microsoft Jet 4.0 OLE DB Provider.
To learn more about the OLE DB connection manager, see OLE DB Connection Manager.
Options
- Data connections
Select an existing OLE DB data connection from the list.
- Data connection properties
View properties and values for the selected OLE DB data connection.
- New
Create an OLE DB data connection by using the Connection Manager dialog box.
- Delete
Select a data connection, and then delete it by using the Delete button.
See Also
Other Resources
Integration Services Error and Message Reference
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
12 December 2006 |
|