Within SQL Server -- I need to copy from a UNC Share to a Local Drive Path.
Normally I would use xp_cmdshell 'XCOPY \\uncserver\sharename\*.* C:\PATH\'
unfortunatly XCOPY does not support reading from a UNC Share and reports an error of file not found, it does exist.
I can even emulate this by making the UNC share on the local-server itself, anybody know the work around for this ?
I'm open to suggestions...
Thanks All in Advance,