Share via

How to Force SSIS to Extract data from read-only excel

tobz 161 Reputation points
2024-12-02T17:37:36.3733333+00:00

Hi Everyone,

I have an SSIS package that loads data from Excel into SQL Server database, currently the package keeps failing with this error: It is already open exclusively by another user or you need permission to view and write its data.

None of these conditions is true, however, right now I want to know if there is a way to force the SSIS to extract data from the file whether or not the file is opened by another user or in read-only mode.

Thank you

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,049 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,619 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 38,956 Reputation points
    2024-12-03T05:27:06.25+00:00

    Hi @tobz

    1. Verify that the file isn’t actual open (check task manager for suspicious EXCEL.EXE processes)
    2. Verify that there are no other SSIS packages (or other background processes) that might be opening this file at the same time

    If you are using agent job to run the package, you may try with proxy account with full permission.

    Run an SSIS Package Under a Different Account

    Regards，

    Zoe Hui

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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.