Web task in SSIS to generate report model

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  December 18, 2015 at 1:26 pm

  #323206

  Hi,

  I was researching on how to regenerate report model automatically and found this link where the developer is using web task to do it.

  http://www.sqlservercentral.com/Forums/Topic442030-147-1.aspx

  My question is I have never used a webtask before..

  I was able to get the HTTP connection setup using URL:

  http://<Server Name>/ReportServer/ReportService2005.asmx?wsdl

  but now when I pull the web task it asks he for WSDL file so I saved the wsdl that was coming from http connection and pointed to it.

  but still I am not able to see the function as shown in the link above RegenerateModel

  Sub Main()

  Dim rs As New ReportingService2005

  rs = New ReportingService2005()

  rs.RegenerateModel("Model")

  End Sub

  I wrote a VB module with this code in a console application and it compiled successfully,

  now ho do I use this method in SSIS to regenerate the report model.

  Thank you so much!!

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]