Lucas the plain set @provstr = 'Text' was what is working for me; the other one was one that i was testing, and not applicable here.
for the error you are getting, I think it's going to be permissions/location of the folder you are using specifically in your case.
what specific path to the folder are you using in your case?
you probably know this, but when you access files or folders or network pats from SQL, it doesn't intuitively use the permissions you might think it should...instead of using YOUR permissions (localadmin/network admin, etc)
it ends up using the startup account of the service...that startup account might not be a domain user(so no network shares work)
or a limited account that doesn't have access to your desktop/my documents/most folders on the drive.
take a look at the startup account you are using:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!