SQLGear

I frequently get request to provide RDLs to developer teams. They do have repository for most of the servers but for those servers which do not have any repository and you need to download RDLs from certain folder it get tedious if there are numerous reports under a folder and its sub folder. The below query will download reports under each folder and subfolder and create same folder structure in the mentioned download folder on the ReportServer. Note: xp_cmdshell should be enabled on the server. --//-- www.SQLGear.net --//-- DECLARE @FullDirectoryPathStatement AS VARCHAR(500) = 'C:\DownloadReport\' SET @FullDirectoryPathStatement = LTRIM(RTRIM(@FullDirectoryPathStatement)) IF RIGHT(@FullDirectoryPathStatement, 1) = '\' SET @FullDirectoryPathStatement = SUBSTRING(@FullDirectoryPathStatement, 1, LEN(@FullDirectoryPathStatement) - 1) DECLARE @FilterReportPath AS VARCHAR(500) = NULL DECLARE @SSRSFolderPath NVARCHAR(850); DECLARE @SSRSFolder NVAR