Error Message: Local path is not a file path or you do not have permission to access it.
Action:
When running a package in Visual Studio that is using COZYROC File Transfer Task and a File Connection Manager pointed to Example - E:\Some_Directory, the package runs fine. However, after deploying the package to SQL Server Agent, the following error message is encountered in the job: "Local path is not a file path or you do not have permission to access it". The error message is coming from File Connection Manager. Attempts to use the UNC path results in same error message. If you navigate to the directory directly from the machine running the job you might be able to access the path E:\Some_Directory, and this gives the perceived impression that the necessary permissions are given to this directory and the job should therefore be able to access the directory without error. Further investigation shows that removing COZYROC File Transfer Task from the equation and using the same File Connection Manager in conjunction with Microsoft's File System Task produces the same error message when deployed and run in SQL Server Agent job.
Error Message:
'Local path is not a file path or you do not have permission to access it.'
Solution:
If you’re running the package via a scheduler such as SQL Agent, you may run into perceived permission problems, or reports that files cannot be found. The issue with schedulers such as Agent is that they run under a “service account” that does not have access to mapped network drives. Creating a proxy account and assigning it to the SQL Server Agent job would likely address the issue.
Please refer to the following link for more info:
https://masudprogrammer.wordpress.com/2015/12/10/ssis-ssis-mapped-network-drives/
Book a Presales Call
Related Articles
Validation error. CozyRoc File Transfer Task <TASK NAME>: '<CONNECTION MANAGER NAME>' connection is not 'FILE' type.'
Action: When configuring a package using the File Transfer Task, the following error is encountered. Error Message: Validation error. CozyRoc File Transfer Task <TASK NAME>: '<CONNECTION MANAGER NAME>' connection is not 'FILE' type.' Solutions: This ...Error Message: 0xC0029183 at <TASK NAME> from <FOLDER NAME>, File Transfer Task: File represented by "/output" does not exist.
Action: When executing an SSIS package with the File Transfer Task, the following error is encountered. Error Message: 0xC0029183 at <TASK NAME> from <FOLDER NAME>, File Transfer Task: File represented by "/output" does not exist. ...Error Message: Validation error. CozyRoc File Transfer Task <TASK NAME>: File usage type of connection '<CONNECTION MANAGER NAME>' should be 'FolderExists’
Action: When configuring a package using the File Transfer Task, the following error is encountered. Error Message: Validation error. CozyRoc File Transfer Task <TASK NAME>: File usage type of connection '<CONNECTION MANAGER NAME>' should be ...How to structure a package using File Transfer Task to Send Files that match my criteria from several local sub-folders
This video demonstrates how to configure a package, using the File Transfer Task, so that it only sends local files to the remote server if they match specified criteria . Several local folders must be scanned to find the files that should be sent.Error Message: The process cannot access the file because it is being used by another process
Action: While attempting to generate the token, the following error message is encountered. Error Message: The process cannot access the file because it is being used by another process Solutions: You have to determine which application is keeping ...