asked
SSIS FST moving files from remote drive to local fails in SQL Agent
Hi everyone, I have been racking my brain with this one all morning. My problem is that I have an SSIS package which moves files from a remote folder to my local server using a file-system-task. The folder is mapped using NET USE and I can access the files fine. When I manually run the SSIS package in BIDS all is ok and the files move to the server. When I schedule this package it succeeds however no files are moved (There are no errors in the job history). I am using an SSIS proxy with domain credentials for the server not the remote folder. The remote drive has different domain details (I think this might be the problem). The package is deployed using SSIS catalog and using SS2012. Any help would be really appreciated.
I am getting this warning: Loop over the files move:Warning: The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty. The file pattern is \*.\* and the directory has files in it.
are you trying to move or copy the files? Are the files marked as read only?
Right. Proxies were failing for me however this link solved it for me.
http://sqlserverselect.blogspot.co.uk/2012/05/ssis-accessing-network-resources-on.html I created an "Execute Process Task" to map the drive before pulling the files. I don't think this is a long term solution however it fixes my immediate issue. Thanks for the help all.
Can you try a different source (on the domain, where you can be 100% certain that permissions are correct) and see if you have the same issue? Alternately, can you temporarily alter the security on the remote location to be EVERYONE allowed and test? This will show if the location and it's applied security settings are the problem.
Hello. Tried with a different folder on the same remote drive. BIDS - all worked fine. SQL-Agent - Succeeded but no files were moved. Tried on a local path (on the same server). Worked under both situations. Wrote a C# script to move the files. BIDS - all worked fine. SQL-Agent - Failed. Couldn't open the location. I cant change the permissions on the remote drive unfortunately as it is hosted by a software provider. I have asked them for FTP access if I cant get this working. Thanks
Can you change the proxy account with your credentials(as you are able to manually run the package) and see whether it is working ? Try to create another domain account (which you have mentioned having access to drive) as a proxy and try ? I feel that there is some issue with the proxy account you have configured for that path.
15 People are following this question.
