When I using SSIS to export data from database.
There are two exception was caught:
The exception detail as below:
SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
--Solution one--
If you're using the Visual Studio to Debugging that SSIS.
Maybe you can revise the 'Run64Runtime' propertie i.e. select the 'False' option:
--Solution--
If you're using a SQL Agent Job to run this SSIS.
If you're using SQL Server 2008, there are shout be a checkbox on the Job Step page to run the package in 32-bit mode.
If you're using SQL Server 2006, you will have to change the Job Step from an Integration Services to an Operating System step, and specify a DTEXEC command line instead. The DTEXEC command line needs to specify the DTEXEC.EXE from the Program File (x86) folders, NOT the DTEXEC.EXE from the Program Files folders.
More information please click the following url:
http://visakhm.blogspot.com.au/2011/12/dtexec-issues-running-ssis-packages-in.html