Hello, is there a good way to have a program (some kind of script) to download (900+) rdl files from sharepoint every night? Thanks

Hey, Considering that you want to download your reports from SharePoint, it shouldn't be difficult at all... All SSRS reports are deployed to a document library in SharePoint, and you could hence map this as a drive to windows explorer. You could then write a simple batch file that copies all files (reports actually) from this mapped location each night through some kind of a windows scheduled job. A more elegant solution would be to run this as part of an SSIS package and have the SQL agent run this each night for you. P.S. It is not an absolute necessity to map the doc. library to your explorer. HTH. Cheers, IceQBPlease mark correct answers :)

You are very correct, sometimes by looking to hard you will miss the "right" way. thanks again