I have a SSIS package that copies a file from one server to another. The source server is on a workgroup, and the target server is on a domain (if it matters). The package executes normally in debug mode, but after I deploy the package to sql server, it fails when trying to access the file on the source server. I assume this is due to a different execution context when running on the server.
I have a mapped drive to the source server, which I am using as the source for the copy function. The directory where the file exists has read/write for everybody. I don't understand why access to this file is being blocked.
Since the user that runs the process (SQL Agent) doesn't exist on workgroup source server, I can't add it to security.
Sql Server 2012 R2.