I am executing SSIS package through stored procedure

Question

Description: 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. End Error Error: 2014-09-30 05:52:58.11 Code: 0xC020801C Source: Load Benefit String Info Excel Source [926] Description: 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.  SSIS package loads the excel data and dumps into sql table. This package runs correctly when run through manual but it didnt work when called from stored procedure. If anybody aware of this error please do let me know.. Thanks in Advance.

arasu selvaraj · Answer

Hi Suthish nair Thank you for u r replay. I have change run time as 32 bit environment. however i am getting the same error. is there any option?.

Suthish Nair · Answer

Error due to Excel Connection Manager which is not supported on 64 bit run time. Change the Execution Options to select and use 32 bit Run time.