Cannot open file because the current provider (SqlServer) cannot open a file.

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

bruce 1565 SSCrazy Points: 2574 More actions · Answer 1

Add a path for the file. For example echo 'xxxx' > C:\temp\tempps.txt

hayden_jones SSCrazy Points: 2099 More actions · Answer 2

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.

hayden_jones SSCrazy Points: 2099 More actions · Answer 3

I just noticed that the Ampersand gt in my last post translated as ">" so I guess that the forum kind of messed with the command you suggested.