(Excel Source) File Processing SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005

Kristy López 0 Reputation points
2023-12-01T20:09:42.7433333+00:00

We are using an excel connection to process files in SSIS (Visual Studio Community 2017) and the process was running well into all of it sudden it stopped processing our files. We have disabled the containers related to excel file processing and unsure how to solve the issue. Can anyone please help? Thank you in advance!

Excel file format is Microsoft Excel 97-2003 Worksheet

We connect the file path to a SharePoint file

Excel Connection Manager > ConnectionString is reading

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=[File path].xls;Extended Properties="EXCEL 8.0;HDR=YES";

Execution error log:

[Excel Source [2]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

[Excel Source [2]] Error: Opening a rowset for "'INSZoom_Client$'" failed. Check that the object exists in the database.

[SSIS.Pipeline] Error: Excel Source failed the pre-execute phase and returned error code 0xC02020E8.

I have verified the that file path is correct in the data source task and connection manager

Double check that the file name follows the same labeling

Verified that the columns (name, data type) in the file match the column names in the EDW table

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,685 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,523 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
966 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,546 Reputation points
    2023-12-04T02:01:05.2133333+00:00

    Hi @Kristy López,

    Please make sure that your account has full permission to access SharePoint.

    In addition you may also set the DelayValidation Property in Connection Manager to true.

    If these do not work, you may follow below steps to connect to SP file.

    See: http://stackoverflow.com/questions/18128632/export-sharepoint-excel-sheet-to-sql-using-ssis

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.