Overview
Excel Connection Manager is SSIS Connection Manager for processing data in Microsoft Excel workbook. Use the API to build components based on Excel Connection Manager.
Setup
Use the Excel Connection Manager dialog to specify properties for opening Excel workbook.
Excel Options
- File
-
Specify Excel workbook file to open.
- RetainSameConnection
-
Specify if all clients should use the same connection. This property has the options listed in the following table.
Value Description True All clients use same connection (default). False Every client use different connection.
- Test Connection
-
Confirm connection manager configuration by clicking Test Connection.
Advanced Options
- Format
-
Specify Excel workbook format. This property has the options listed in the following table.
Value Description Automatic Automatically determines Excel workbook format from specified file extension (default). Excel 97-2003 97-2003 Excel workbook. Excel 2007 2007-2010 Excel workbook. Requires installation of .NET 3.0 or later. Pocket Excel Pocket Excel.
- Open Password
-
Specify password to open Excel workbook.
- Modify Password
-
Specify password to modify Excel workbook.
- Recalculate
-
Specify to recalculate and update external references in Excel workbook on open. This property has the options listed in the following table.
Value Description True Excel workbook is recalculated on open. False Excel workbook is not recalculated on open (default).
