Moving a SSRS report and datasource from 2008r2 to 2012

• Yakko_Warner

  Ten Centuries

  Points: 1266

  More actions

  March 8, 2016 at 10:20 am

  #324808

  I am attempting to move 1 report and 1 datasource from a 2008r2 server to 2012 server using rsscripter.

  I got the files generated and When i Run the .cmd it comes back with:

  Running script "C:\tempreports\reports\Records Management\DestructionDate.rdl.rss"

  Error : rsItemNotFound (The item '/reports/Records Management' cannot be found.)

  The command completed successfully

  I have the files in the the C:\tempreports\reports\ like it should be.

  Just can't figure out what's going wrong here.

  Thanks in Advance!

• Yakko_Warner

  Ten Centuries

  Points: 1266

  More actions

  March 10, 2016 at 11:02 am

  #1864322

  Would it be useful if i paste in the cmd. code i am running?

  here it is:

  @echo off

  :: ** Script generated by Reporting Services Scripter 2.0.0.17 **

  :: ** Created by Jasper Smith (jas@sqldbatips.com) **

  :: ** See http://www.sqldbatips.com for help/support **

  ::Script Variables

  SET LOGFILE="RS Scripter Load Log.txt"

  SET SCRIPTLOCATION=C:\tempreportsSET BACKUPLOCATION=

  SET REPORTSERVER=http://localhost/ReportServer

  SET RS="E:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\RS.EXE"

  SET TIMEOUT=60

  ::Clear Log file

  IF EXIST %logfile% DEL %logfile%

  ::Write Log Header

  ECHO Reporting Services Scripter Load Log 2.0.0.17 >>%LOGFILE%

  ECHO. >>%LOGFILE%

  ECHO Starting Load at %DATE% %TIME% >>%LOGFILE%

  ECHO SCRIPTLOCATION = %SCRIPTLOCATION% >>%LOGFILE%

  ECHO REPORTSERVER = %REPORTSERVER% >>%LOGFILE%

  ECHO BACKUPLOCATION = %BACKUPLOCATION% >>%LOGFILE%

  ECHO SCRIPTLEVEL = SQL2008 >>%LOGFILE%

  ECHO TIMEOUT = %TIMEOUT% >>%LOGFILE%

  ECHO RS = %RS% >>%LOGFILE%

  ECHO. >>%LOGFILE%

  ::Run Scripts

  ECHO Running script "%SCRIPTLOCATION%DataSources\TabFusionDB.rds.rss" >>%LOGFILE%

  %RS% -i "%SCRIPTLOCATION%DataSources\DBdatasource.rds.rss" -s %REPORTSERVER% -l %TIMEOUT% -v BACKUPLOCATION="%BACKUPLOCATION%" >>%LOGFILE% 2>&1

  ECHO. >>%LOGFILE%

  ECHO Running script "%SCRIPTLOCATION%reports\Records Management\DestructionDate.rdl.rss" >>%LOGFILE%

  %RS% -i "%SCRIPTLOCATION%reports\Records Management\DestructionDate.rdl.rss" -s %REPORTSERVER% -l %TIMEOUT% -v BACKUPLOCATION="%BACKUPLOCATION%" >>%LOGFILE% 2>&1

  ECHO. >>%LOGFILE%

  ECHO. >>%LOGFILE%

  ECHO Finished Load at %DATE% %TIME% >>%LOGFILE%

  ECHO. >>%LOGFILE%

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  March 10, 2016 at 11:26 am

  #1864333

  Run as Admin?

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  March 10, 2016 at 12:44 pm

  #1864371

  Create the folder "Records Management" on the new server?

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]