Home Forums Data Warehousing Integration Services My SSIS import from Excel package works from my PC, does not from Server RE: My SSIS import from Excel package works from my PC, does not from Server

  • Vic Rauch-303403 (10/1/2014)


    I have created, very carefully, a new SSIS package to import Employee data from an Excel spreadsheet file. File name is "Employee.xlsx" This same SSIS package is also designed to import data from a SECOND Excel spreadsheet file for some operational data. The name of that second spreadsheet file is: "OperationalData.xlsx" The sheet that holds the data for the Employee data is titled "Detail." The sheet that holds the data for the Operational Data is titled "Sheet1."

    This SSIS package runs great from my PC using the 32 bit runtime. Just before deployment, I change that to use 64 bit runtime as the runtime on the server is 64bit. The error I get when the package is executed from the SSIS Catalog on the server is: "Opening a rowset for “Sheet1$” failed" (I know the "$" is added when used in executable code.) Of course, "Sheet1$" can be found by this very same code when run from my PC, but when executed from the Catalog of the server, "Sheet1$" can't be found.

    If someone has an answer to this problem, I would surely love to get it so I can get this working.

    The Run64BitRuntime setting is only used in Visual Studio. It has no impact whatsoever on the package in production.

    Does the account executing the package have access (and permission) to the Excel file?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP