This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Hi
I have an SSIS package which will write data from a DB source onto an Excel file on the sharepoint share (\sharepoint\folder\file.xlsx).
This works fine through Visual Studio but fails when it is deployed to the SSIS Server and called from another SQL Server through a SQL Agent job it fails with
The SQL Agent job runs as a service account. I have logged into the SSIS server as the service account and run the package manually and it works. Is this a double hop issue? Is it easy to fix?
Is this a double hop issue?
No. Read the error message: Access denied, the Agent service account don't have permissions to access/write to SharePoint.
Is it easy to fix?
Yes, create a SQL Server Agent Proxy Account, e.g. with your AD credentials and use that one to execute the job step.
Hi Olaf
This is using a proxy account, the same service account I used to login to the SSIS box and manually execute the package successfully. It is only when the package is called from a second SQL instance.
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hi @Anonymous ,
May I know if you create a SQL Server Agent Proxy in the second SQL instance?
Please refer to How to configure OData SSIS Connection for SharePoint Online.
Best regards,
Mona
----------
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.
Hi Mona
SQL Server A has the proxy account and the job
SQL Server B is the SSIS server
We have over 20 SSIS packages working this way its only this access to SharePoint.
This is not using ODATA this is using an EXCEL destination but the location is \sharepoint\sites\SITENAME\Folder\File.xlsx
Thanks
Sam
Hi @Anonymous ,
Please check if the proxy account has permission to access to the files.(\sharepoint\folder\file.xlsx)
Hope the following links will be helpful:
1.SSIS - Sharepoint excel as datasource
2.How to Use Powershell or SSIS to Download a Sharepoint File
Best regards,
Mona