SSIS Error loading Excel sheet to table - OLEDB error

I'm trying to create a data flow task which brings data from Excel File to SQL table. I'm doing it in SQL Server Data Tools for Visual Studio 2012 as an SSIS package. However, when I run the task I receive below error:

Complete error message:

TITLE: Microsoft Visual Studio

Exception from HRESULT: 0xC02020E8
Error at Import Leads DM Forecast CPPs prep [Excel Source [579]]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

Error at Import Leads DM Forecast CPPs prep [Excel Source [579]]: Opening a rowset for "CPPs$" failed. Check that the object exists in the database.

BUTTONS:

OK

some overview: I have .xlsx file and have multiple tabs in it. But i have to read only one sheet where i am using Data access mode: table or view and specifying the Excel Sheet name as CPPs$. (sheetname is CPPs) I get this file once a year. in the excel sheet i have 4 columns and they have filter on each column. column A has mmyyyy data. i am not sure where i am going wrong in loading the excel DATA TO TABLE.

Would you be able help please?

I don't typically work with Excel files (CSV instead). My recommended troubleshooting would be to create the connection through the Source Assistant (make sure you choose the correct version of Excel) to rule out the connection manager. Its possible you have bad data in the Excel file (like blank rows or something), so you might want to copy the data from the CPP tab into a new workbook, with one tab only, and then delete all blank rows and columns as a precaution. Then inspect the remaining data field for invalid characters. I hope that helps.