Is there any known issue with EXcel source/ destination in SSIS 2008 ?
I have got the below error when the excel is either source or destination along with OLEDB...
[Excel Destination ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[Connection manager "Excel Connection Manager"] Error: 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.
As the second error says it not supported 64 bit version, mine is SQL 2008 64 bit .
So is there any solution for this ?
Thanks & Regards,