SSIS Error loading Excel file to table
-
Hi
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.
i am not sure where i am going wrong in loading the excel DATA TO TABLE.Would you be able help please?
Thank you
Swathi. -
The filters can exist, but if you have the file saved after having actually used the filter to filter out rows, what you get might either be this error or you might not get the results you are looking for. If you are hoping to only import rows that show after implementing a filter, don't even think about it. Not going to happen. Make sure none of the filters are active before trying to import the data. If you need to import only filtered data, then copy the filtered data to a new tab and then import from the new unfiltered tab.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply