I have a ssms job running a stored procedure that outputs a .txt file to a folder on one of our file servers. Works great! Now I need to take the same job and redirect it to a SharePoint 2010 Library folder. After changing the output destination folder's UNC, the error "Executed as user: domainname\username. Unable to open Step output file. The step succeeded." is generated.
The domainname\username is the account assigned to the SQL Server service and to the SharePoint 2010 Library folder with Full Control. I'm using the full UNC in the step output path with filename in the Job Step's definition, similar to the prior working scenario. Any suggestions or direction to go is appreciated.
Thank you in advance.