Excel OLEDB Connection
Declares an 'ExcelConnection' that points at an Excel 2007+ workbook through the Microsoft ACE OLE DB 12.0 provider. The 'Extended Properties' fragment sets 'Excel 12.0 Xml' (for .xlsx) and 'HDR=YES', so the first row of each sheet is treated as a header. Replace the 'Data Source' path with the location of your own workbook, and install the matching ACE 64-bit or 32-bit runtime so SSIS can load the provider at execution time.
<Biml xmlns="http://schemas.varigence.com/biml.xsd">
<Connections>
<ExcelConnection Name="ExcelOleDbConnection" ConnectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\MyExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";" />
</Connections>
</Biml>