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
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
Post a Comment