Using .xlsx sources with SSiS (64 bit) on a 64 bit system

The only way I’ve found to run an SSIS data flow with an .xlsx as source and without changing the option ’64 runtime’ to false is to use as source an “OLE DB source” component in the data flow with this query:

select * FROM OPENROWSET (‘Microsoft.ACE.OLEDB.12.0’

, ‘Excel 12.0;Database=C:\Hello.xlsx’

, [Sheet1$]

)

By the way, to make it works, you have to install the ACE drivers(for 64 bit) from microsoft website on the machine where you execute your package. 🙂

Advertisements