PowerShell Copy on a mapped or UNC Drive (SQL Server Job Agent) -


what doing wrong?

as step in job trying overwrite file copying drive mapped, using unc path in case.

in powershell works in command line interface.

copy \v240\folder\foo.txt \v240\folder\bar.txt

1

when put in job agent in sql server powershell option says completed file has not been copied.

the powershell sql agent job step starts powershell sqlps host in sql server provider. try setting location (cd) filesystem provider before copying

set-location c:\ copy \v240\folder\foo.txt \v240\folder\bar.txt 

Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -