Post reply

Generate SSRS reports from a SSIS Package

  • December 7, 2016 at 2:11 pm

    #1916627

    how i can add parameters in to it?

  • July 26, 2017 at 7:58 am

    #1952775

    Hi Thanks for the wonderful reply. I also tried the same method, but i'm not able to add web service reference, getting an error "The HTML document does not contain Web service discovery information.Metadata contains a reference that cannot be resolved: "
    Could you please tell which part i'm missing.

  • July 27, 2017 at 1:55 am

    #1952956

    Hi,
    https://technet.microsoft.com/en-us/library/ff793463(v=sql.105).aspx

    i.e.,
    1)  Double click on box script component
    2)  Edit  Script (down-right)
    3)  Right click References (Under Solution Explorer tree)/ Add Service Reference
    4)  Advanced (down-left) 
    5)  Add Web Reference (again down-left)
    6)  Type in box for URL this: http://nebojsak2/ReportServer/ReportExecution2005.asmx (nebojsak2 stands for localhost name like development machine)

    You should get this  in prompt window:

    I believe that those were steps I undertook in order to Add needed Service for

    Bulk Report Generation using SSIS and SSRS

    Of course, in order to work, you should have prepared ReportConfig table etc...like explained in mentioned tutorial, have created all necessary reports....Bye

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply