SSIS 作业无法访问 Azure 文件共享路径
我正在使用 Azure VM 上托管的 SSIS 测试 azure 文件共享。但是，我在运行作业时遇到了问题。
- 通过 Visual Studio 执行包成功
- 通过目录执行包也成功
通过作业执行包失败并出现错误 连接中指定的文件名“\.windows.net
我尝试过使用有权访问 Azure 共享文件夹的代理帐户（用于运行包的帐户）运行作业，但失败并出现相同的错误。
UNC 和映射驱动器都经过测试。
对此的任何建议或意见将受到高度赞赏。
提前致谢。
I am testing the azure file share with SSIS hosted on Azure VM. However, I am facing an issue while running the job.
- Package execution through Visual Studio is successful
- Package execution through catalog also is successful
Package execution through the Job is FAILING with the error The File Name "\.windows.net<FolderName>\file.csv" specified in the connection was not valid
I tried running the job with the proxy account having access to the Azure share folder (Same account used to run the package), however it failed with the same error.
Both UNC and as a mapped drive was tested.
Any suggestion or advice on this will be highly appreciated.
Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试向 SQL 数据库引擎服务帐户
NT SERVICE\MSSQL$和NT SERVICE 授予读/写权限（对于 Azure 共享文件夹） \SQLSERVERAGENT（其中另外，请随时阅读以下文档中有关 SQL Server 服务帐户的更多信息：
Try giving read/write permissions (For the Azure share folder) to the SQL Database Engine Service account
NT SERVICE\MSSQL$<Instance Name>andNT SERVICE\SQLSERVERAGENT(Where<Instance Name>should be replaced by the installed instance name):Also, feel free to read more about SQL Server service accounts in the following documentation: