在服务器之间复制文件时，SSIS文件系统任务错误 [英] SSIS File System Task Error while copying files between servers
问题描述
我可以手动在两台服务器（例如服务器A和服务器B）之间复制文件，并且我有权访问两边的文件夹。
I can copy files between two servers say Server A and Server B manually and I have permissions to folders on either side.
我正在使用文件系统任务进行复制文件。
I am using File System Task to Copy files.
当我的源和目标在服务器中时，该包在Visual Studio和SSISDB中都可以正常工作。
When my Source and Destination are within the Server the Package works fine in visual studio as well as SSISDB.
当我的源服务器和目标服务器位于不同的服务器中时，该程序包在Visual Studio中工作正常，但在SSISDB中程序包失败。就是说访问被拒绝。我的帐户已映射到SSISDB。
When my Source and Destination are in different Servers the Package works fine in visual studio but package fails in SSISDB. It is saying access is denied. My Account is mapped to SSISDB.
解决此问题的任何想法。
Any idea to solve this issue.
使用SQL Server代理JoB。作业是通过代理帐户运行的。
The package runs fine using the the SQL Server Agent JoB. The job is run through the proxy account.
我们可以通过任何方式将Package配置为通过代理帐户运行。
Any way we can configure Package to Run through proxy account.
错误屏幕截图
推荐答案
首先@ Nick.McDermaid在评论中提供了一个非常有用的链接，以详细了解
在搜索后，有很多可能导致此问题的问题，因此我将提供许多解决方案，可以解决您的问题问题。
1。 SQL Server帐户权限
添加读取并添加对您在指定路径上登录的帐户的写权限
Add Read & Write permissions to the The account you are logged in on the specified paths
2。向网络帐户添加Windows身份验证
您可以为网络帐户（在sql Server代理中用作代理）添加Windows身份验证登录名，然后运行
You can add a Windows authentication login for the network account (used as proxy in sql server agent) and run the package using it.
这不是您的情况，但是这些信息可能会帮助
1。 SQL Server帐户权限
添加读取并添加在指定路径上向以下帐户写入权限：
Add Read & Write permissions to the following accounts on the specified paths:
-
NT SERVICE\SQLSERVERAGENT -
NT SERVICE\MSSQLSERVER
NT SERVICE\SQLSERVERAGENTNT SERVICE\MSSQLSERVER
2。设置代理
您可以为SSIS软件包设置代理，并使用该代理帐户运行作业。
You can setup a proxy for the SSIS package and run the job using that proxy account.
您可以参考以下链接之一以了解更多信息：
You can refer to one of the following links to learn more:
- Running a SSIS Package from SQL Server Agent Using a Proxy Account
- Setting up a Proxy Account to run SQL Server Integration Services (SSIS) 2012 packages
3。将网络驱动器映射到SQL Server实例
有些文章建议将您正在SQL Server（而不是OS）上使用的网络驱动器映射。以下链接之一以了解更多信息：
Some articles suggests to map the network drives you are using on SQL Server (not the OS).You can refer to one of the following links to learn more:
- Make Network Path Visible For SQL Server Backup and Restore in SSMS
- Configure Network Drive Visible for SQL Server During Backup and Restore Using SSMS
4。添加SysAdmin角色
将SysAdmin角色添加到以下帐户：
Add SysAdmin Role to the following accounts:
-
NT SERVICE\SQLSERVERAGENT -
NT SERVICE\MSSQLSERVER
NT SERVICE\SQLSERVERAGENTNT SERVICE\MSSQLSERVER
- < a href = https://dba.stackexchange.com/questions/29798/access-denied-when-trying-to-run-an-agent-job>尝试运行代理作业时拒绝访问
- 如何解决SQL Server Management Studio中的SSIS访问被拒绝错误
- 从SSIS目录执行软件包时无法访问网络共享
- SSIS包中的拒绝访问路径错误
- 文件系统任务错误；
- [文件系统任务]错误：发生了错误以下错误消息：拒绝访问路径。
- 访问路径被拒绝错误
- 文件系统任务-从一个文件夹复制到另一个文件夹会得到错误-访问路径被拒绝
- Access denied when trying to run an agent job
- How to resolve SSIS access denied error in SQL Server Management Studio
- Can't access a network share when executing a package from the SSIS Catalog
- "Access to the path is denied" error in SSIS package
- File system task error ; Access to the path " " is denied
- [File System Task] Error: An error occurred with the following error message: "Access to the path is denied."
- Access To The Path Is Denied Error
- File system Task -copied from one folder to another folder get the error - Access path is denied
这篇关于在服务器之间复制文件时，SSIS文件系统任务错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
