I guess it has to do with some permissions on file, though you said it can access the schema.

Try granting the read/write access to the folder to the SQL service account..