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.
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.
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.
Excel file path
Type the path and file name of an existing or a new Excel workbook file.
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.
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.