question

@SQLShark avatar image
@SQLShark 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.
ssissql-server-agentmovejob-history
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
are you trying to move or copy the files? Are the files marked as read only?
0 Likes 0 ·
No not read-only.
0 Likes 0 ·
@SQLShark avatar image
@SQLShark answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
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.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·
Venkataraman avatar image
Venkataraman answered
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.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi Ven. Sorry for the delay. I will have a play with the proxy. I will get back to you.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.