Excel Connection

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Questions?

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).