Are UNC paths allowed?

Nov 4, 2011 at 5:11 PM

I'm trying to copy a file from a remote sftp site to a remote (but local on the network) share.  My SSIS package is running on a dedicated ssis server, but the file it gets needs to be on our application server.  I'm not sure if I'm doing it wrong, or if this task even supports using a windows share.

i.e. Local path = \\servername\drive$\folder\folder"

Nov 5, 2011 at 1:17 PM

Frankly I didn't test using your pattern "\\servername\drive$\folder\folder", but "\\servername\folder\folder" it's working. Eventually, add a backslash at the end "\\servername\folder\folder\" or "\\servername\drive$\folder\folder\". You have to pay attention with the shared folders because that involves some network restriction even if it's you the creator of the folder on your own machine as Admin of the machine.

Nov 7, 2011 at 4:27 PM

Thanks for the info.  I'll give it a shot, we've been using the drive$ unc for the old regular FTP connection with no problem so I'm pretty confident in the access rights via that method.  I'll have to verify them the other way.