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++ - Is it possible to compile a VST on linux? -

java - Output of Eclipse is rubbish -

jquery - Confused with JSON data and normal data in Django ajax request -