Excel Connection Manager

An Excel connection manager enables a package to connect to a Microsoft Excel workbook file. The Excel source and the Excel destination that Microsoft SQL Server Integration Services includes use the Excel connection manager.

Important

For detailed info about connecting to Excel files, and about limitations and known issues for loading data from or to Excel files, see Load data from or to Excel with SQL Server Integration Services (SSIS).

When you add an Excel connection manager to a package, Integration Services creates a connection manager that is resolved as an Excel connection at run time, sets the connection manager properties, and adds the connection manager to the Connections collection on the package.

The ConnectionManagerType property of the connection manager is set to EXCEL.

Configure the Excel Connection Manager

You can configure the Excel connection manager in the following ways:

  • Specify the path of the Excel workbook file.

  • Specify the version of Excel that was used to create the file.

  • Indicate whether the first row in the selected worksheets or ranges contains column names.

    You can set properties through SSIS Designer or programmatically.

    For more information about the properties that you can set in SSIS Designer, see Excel Connection Manager Editor.

    For information about configuring a connection manager programmatically, see ConnectionManager and Adding Connections Programmatically.

Excel Connection Manager Editor

Use the Excel Connection Manager Editor dialog box to add a connection to an existing or a new Microsoft Excel workbook file.

Options

Excel file path
Type the path and file name of an existing or a new Excel workbook file.

Browse
Use the Open dialog box to navigate to the folder in which the Excel file exists or where you want to create the new file.

Excel version
Specify the version of Microsoft Excel that was used to create the file.

First row has column names
Specify whether the first row of data in the selected worksheet contains column names. The default value of this option is True.

Load data from or to Excel with SQL Server Integration Services (SSIS)
Excel Source
Excel Destination