Acess excel file from a shared folder aftre deployment

Kesha Shah 1 Reputation point
2021-09-07T08:08:30.027+00:00

Hello everyone,

I've created one SSIS package. In which I'm transferring data from excel file to SQL Server. Source file i.e excel file is located in a shared folder that is password protected. When I execute this package in SSDT, it works absolutely correct. However, after deployment, when I execute this same package, it shows the following error:
![129797-image.png]1
Can anyone help me out how I can access excel file from a shared folder aftre deployment? What configurations I need to perform to get this done?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,736 Reputation points
    2021-09-07T08:33:37.423+00:00

    Hi @Kesha Shah ,

    I assume that the you are running the SSIS package under SQL Server Agent Service Account, which may not have the right authority to read/write files from the shared folder.

    You need to set up a proxy account that uses a domain account credentials. The domain account should have the right level of permissions to read/write files in the shared folder.

    Details you may refer: create-a-sql-server-agent-proxy

    Regards，

    Zoe

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October