Need to scheduled an SSRS report to save to a SharePoint document library

I want to schedule an SSRS subscription to save directly to a SharePoint document library and I can't. I get the error "Failure writing file \server\path\report.pdf: Access to the path '\server\path\report.pdf' is denied.

Here are the facts:

- I get a different error if I use the user/pass combo for the subscription, so I know my user/pass is correct

- I can save to all other shared file areas I have tried

- I can log into the SSRS server and map to the SP UNC path and write documents to it

- unlike other mappings I've done on the SSRS server, the SP directory does not stay mapped, even though I have clicked 'reconnect at login'

- SSRS Server is Win 2008; SP is 2008 (I thi开发者_高级运维nk)

- we have turned on WEBDAV and installed Desktop Experience

- SP integrated mode is not an option

Any ideas or nudges in a general direction are greatly appreciated!

If installing SSRS in SharePoint integrated mode is not an option, then you will need to write custom code.

Set the SSRS subscription to write out to a local path on the SQL server, and then set a recurring scheduled task to run your custom .exe.

The custom .exe should copy the contents of a local directory to a given SharePoint document library. The .net SharePoint objects make this pretty easy: you'll probably spend more time getting the project set up than writing code to copy the files.

I got it to work by

• Enabling WEBDAV
• Turning Desktop Experience mode on
• Mapping the Http file connect path that sharepoint gives to as a drive

For some reason when i did that it gave me the ability to write directly to the sharepoint folder on the server. \sharepoint-server\sites\path\shared documents\

Hi try configuring the centeral admin first http://msdn.microsoft.com/en-us/library/bb326213.aspx

then follow the following post to configure delivery to sharepoint library

http://msdn.microsoft.com/en-us/library/bb283186.aspx