The full path works, though I am wondering why the command works in normal powershell without the path

and sqlps needs the path. I would ask why the error message lies and says sqlps doesn't have permission to open a file

but I figure, hey, this is Microsoft.

I don't quite follow the > syntax. What is that intended to do? I find that

echo 'xxxx' > C:\temp\tempps.txt errors out and that

echo 'xxxx' > C:\temp\tempps.txt does work.