question

KeshaShah-2894 avatar image
0 Votes"
KeshaShah-2894 asked Zoehui-MSFT commented

Acess excel file from a shared folder aftre deployment

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
image.png (8.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered Zoehui-MSFT commented

Hi @KeshaShah-2894,

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




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·