A SSIS package, package involves mapped drives from the network operation file, copy to delete, etc., within the VS everything is normal, the packet is deployed to the SSIS manually invoked is normal, after the call with the homework, implement the success, but warned that directory may be empty, in SQL2012 and 08 r2 were unable to get file, to network within the VS mapped drives is considered to be a local path can be normal operation, but if with a JOB call, believe the path for the network path, whether you need the folder of the mapped drives the security option within the SQL agent account, before SQL2012 test in the local folders folder is the folder on added after account of the agent can be normal operation, or have other way,
Use the exec master.. Arbitrary command shows "system error 5, access denied"

CodePudding user response:

Local produce, and then through a Shared network disk which FTP methods such as access to files on the server, it is safer,

CodePudding user response:

Try the Windows account to start SQL agent service

CodePudding user response:

Forgot to say the mapped drives is SFTP directory, whether for SQL does not support SFTP network mode, VS through FTP link chain to SFTP, can only be done by mapping a network drive mode,

CodePudding user response:

Mapped drives the folder - right - attributes - security - add everyone to read and write permissions.

CodePudding user response:

Before the permissions have been added to the account, whether or not to change the local server proxy account login permissions to EVERYONE, thank you