Error SSIS Excel Source - connection manager incorrect type

See more:

SQL

MS-Excel

SSIS

Hi,

I am trying to import from Excel to SQL Server using SSIS through code and used the following connection information.

connectionManager = package.InnerObject.Connections.Add(ExcelMoniker);
connectionManager.Properties["ConnectionString"].SetValue(connectionManager, string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=YES""", excelDataSource.FileName)); 

At the time of AcquireConnections method calling it is throwing an exception
"Exception from HRESULT: 0xC020801E"
The connection manager "__" is an incorrect type. The type required is "__". The type available to the component is "__".

Please help.

Regards,
hari.