Error Opening Excel file in SSIS package

  • Hello.

    I have a small Excel 2016 spreadsheet file to be used as source data file.  The SSIS package will open that source data file then load that source data into a staging table for subsequent processing.

    I created an Integration Services Package and included an Excel Connection Manager and an Excel Source task

    When I edit the Excel Source Task and browse to the Excel file, I click the Preview button and the data shows.

    I verified that the Excel file is where it should be.

    However, when I try to run the package, I get the following errors:

    [Excel Source [100]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37.
    [Excel Source [100]] Error: Opening a rowset for "Sheet1$" failed. Check that the object exists in the database.
    [SSIS.Pipeline] Error: "component "Excel Source" (100)" failed validation and returned validation status "VS_ISBROKEN".

    Has anyone experienced this before?

  • I'm presuming when it fails, you're trying to run it as a scheduled Agent job?  If so, you need one of two things on the server itself, either:
    1.  MS Excel installed
    2.  The MS Access Redistributable (either x64 or x86 depending on if your SSIS package is running in 32-bit or 64-bit)

    I've had to assist developers here in getting SSIS to read Excel files, works fine when they ran the package themselves, but when it runs on the server it fails.  They have Excel on their workstations.

  • From the OP's post, Jasona, I'm actually not so sure that they have indeed deployed, my understanding is that they are actually running the package within VS; I could be wrong. If so, however, then the credentials of the user would be whoever opened VS, and, also, as they managed to preview then they do indeed have permissions to access the file. Odd.

    Annoying, I don't have SSIS at home (no SSDT on Linux yet 🙁 ) and I'm not at the normal office tomorrow... I have a few ideas, but I really don't want to bat them out as they could be utter nonsense. Heh. If I get to RDP into the office tomorrow I'll give something a quick try and post back if no one else has given a solution.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply