July 15, 2010 at 10:13 am
Hello,
I used to use, in SQL 2005, the backwards compatible mgmt2000 endpoint to executre rss files with the rs utility to render reports to a file directory.
Example: rs -i myrssfile.rss -e mgmt2000 -s http://localhost/reportserver -l 0
Now I have a 2008 server, and as far as I can tell I am forced to use the 2005 web server, and use the exec2005 end point to execute reports. However, I am having a great deal of trouble finding any resources on scripting for this web serverice end point.
Example: rs -i myrssfile.rss -e Exec2005 -s http://localhost/reportserver -l 0
Can someone please tell what what replaces the following lines of code as errored by my execution output? or point me to some sort of execution sample that will allow me to execute multiple reports and output to a file directory.
Errors:
C:\Users\Administrator\AppData\Local\Temp\2\zgrd2kiz.1.vb(379) : error BC300
02: Type 'DataSourceDefinition' is not defined.
Dim definition As DataSourceDefinition = Nothing
~~~~~~~~~~~~~~~~~~~~
C:\Users\Administrator\AppData\Local\Temp\2\zgrd2kiz.1.vb(383) : error BC304
56: 'GetDataSourceContents' is not a member of 'Microsoft.SqlServer.ReportingSer
vices2005.Execution.ReportExecutionService'.
definition = rs.GetDataSourceContents(datasourcepath & "/PRA_Data")
~~~~~~~~~~~~~~~~~~~~~~~~
C:\Users\Administrator\AppData\Local\Temp\2\zgrd2kiz.1.vb(393) : error BC304
56: 'SetDataSourceContents' is not a member of 'Microsoft.SqlServer.ReportingSer
vices2005.Execution.ReportExecutionService'.
rs.SetDataSourceContents(datasourcepath & "/PRA_data", definition)
~~~~~~~~~~~~~~~~~~~~~~~~
C:\Users\Administrator\AppData\Local\Temp\2\zgrd2kiz.1.vb(412) : error BC300
02: Type 'CatalogItem' is not defined.
dim report as CatalogItem
~~~~~~~~~~~
C:\Users\Administrator\AppData\Local\Temp\2\zgrd2kiz.1.vb(437) : error BC300
02: Type 'SessionHeader' is not defined.
Dim sh As New SessionHeader()
~~~~~~~~~~~~~
C:\Users\Administrator\AppData\Local\Temp\2\zgrd2kiz.1.vb(438) : error BC304
56: 'SessionHeaderValue' is not a member of 'Microsoft.SqlServer.ReportingServic
es2005.Execution.ReportExecutionService'.
rs.SessionHeaderValue = sh
~~~~~~~~~~~~~~~~~~~~~
C:\Users\Administrator\AppData\Local\Temp\2\zgrd2kiz.1.vb(573) : error BC300
02: Type 'CatalogItem' is not defined.
Dim reports() as CatalogItem
~~~~~~~~~~~
C:\Users\Administrator\AppData\Local\Temp\2\zgrd2kiz.1.vb(574) : error BC304
56: 'ListChildren' is not a member of 'Microsoft.SqlServer.ReportingServices2005
.Execution.ReportExecutionService'.
reports = rs.ListChildren(basereportpath, False)
~~~~~~~~~~~~~~~.
July 15, 2010 at 10:20 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic953285-162-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply