通过

Reporting Services(SSRS) Reports deployment using batch file(command line)

  • 项目

Create a batch file SSRS_Deployment.bat which will contain following code :

@Echo Off

for /f "tokens=2 delims=," %%a in ('type Config.csv ^| find "SSRS Reports Folder"') do set sourcePath=%%a

for /f "tokens=2 delims=," %%a in ('type Config.csv ^| find "SSRS Target Server"') do set SSRSTargetServer=%%a

for /f "tokens=2 delims=," %%a in ('type Config.csv ^| find "SSRS Target Folder"') do set SSRSTargetFolder=%%a

echo.*****************************************************************************
echo "SSRS Reports Deployment Started"
echo.*****************************************************************************
echo.

for %%f in ("%sourcePath%\*.rds") do XMLEditor %%f %DatabaseTargetServer% "rds"

for %%f in ("%sourcePath%"\*.rds) do rs -i MyRSS_rds.rss -s %SSRSTargetServer% -v sourcePath="%sourcePath%" -v targetFolder="%SSRSTargetFolder%" -v dataSource="%%~nf" -e Mgmt2010

for %%f in ("%sourcePath%"\*.rdl) do rs -i MyRSS_rdl.rss -s %SSRSTargetServer% -v sourcePath="%sourcePath%" -v targetFolder="%SSRSTargetFolder%" -v reportName="%%~nf" -e Mgmt2010

 

echo.*****************************************************************************
echo "SSRS Reports Deployment completed"
echo.*****************************************************************************
echo.

pause

 

 

All the required files are attatched in this post.

Zip file which contains following files :

  • Config.csv - This has all the configuration settings like folder name,server name etc.
  • MyRSS_rdl.RSS
  • MyRSS_rds.RSS
  • MyRSS_Folder

This deployment is for SSRS 2008 R2 in both native and sharepoint mode.Only SSRS 2008 R2 supports integrated mode command line deployment.For other lower versions of sql server remove -e Mgmt2010 from command.

 

MyRSS_rdl.zip

Comments

  • Anonymous
    March 28, 2011
    The comment has been removed
  • Anonymous
    November 21, 2012
    Reference to what and where XMLEditor is would be helpful, given that it's at the core of the script. There's dozens of XMLEditor apps out there, reference to which one it is would provide context to improve the usefulness of this post.