Hi,
I'm trying to connect to Excel file and import the file to a server.
Where's the error I get:
Error: 2008-07-10 11:50:52.97
Code: 0xC020801C
Source: Copy Data from Final$ to DP dbo MOL_AP_DataFromExcel Task Excel Source [516]
Description: An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
End Error
When I change the Runtime from 64 to 32 in package proprietes, it's working in SQL Server Business Intelligence Development Studio, but not on the server.
Server : Windows server 2003 64
DB: SQL Server 2005
Thanks,