Thursday, May 8, 2008

ActiveX Script Task to access a Report on a Report Server in SSIS 2008

The following ActiveX Script used in an ActiveX Script task can can display a web page in the IIS web server. However the task may fail. This is one of identified bugs.

Code:
Function Main()

Set oIE = CreateObject("internetExplorer.Application")oIE.navigate "http://localhost/SilverLight/TestSilverLight.htm"
oIE.Visible = true
end function


To display a Report deployed to a Report Server (Sql Server 2008) the following script can be used. Notice the processing instructions in addition to the URL of the report,

Code:
Function Main()

Set oIE = CreateObject("internetExplorer.Application")oIE.navigate "http://hodentek2:8080/ReportServer/Pages/ReportViewer.aspx?%2fRSProject%2fpubsAuthors&rs:Command=Render"
oIE.Visible = true
end function

Make sure the Report Services is running.

The task completes but the task fails. Opa!

Here are the Execution Results:

No comments: