Post reply

SSRS Report to SSIS

  • June 4, 2012 at 1:01 pm

    #274989

    Hi All,

    I have a SSRS Report 2005,

    Can we run SSRS report in SSIS? Is it possible?

    Ex: If we have SSRS report, we can run SSRS report in vb.net / asp.net by using SSRS Report file name/path name/URL link...If we do all these process the SSRS report output will be shown in vb.net/asp.net

    In the same way in need SSRS Report output to be shown in SSIS.

    Please let me know how to do this? Thank you in adv!!

  • June 4, 2012 at 1:36 pm

    #1496715

    help me plz..

  • June 4, 2012 at 1:45 pm

    #1496727

    I am not sure that I understand.

    By talking about SSIS, do you say that you need to distribute a report or get it onto another server?

    Mentioning VB, are you trying to present a report, or reports, in a .NET application?

    Please clarify.

    Thanks.

  • June 4, 2012 at 1:55 pm

    #1496736

    I have a SSRS report and i want to run this SSRS report in SSIS

    Can i run it in SSIS? If yes, how to run?

  • June 4, 2012 at 1:57 pm

    #1496740

    Because i can run the same SSRS report in vb.net/asp.net

    and i can see the ssrs output in vb.net/asp.net

    In the same way can i do it in SSIS? Is it possible?

  • June 4, 2012 at 2:31 pm

    #1496766

    No, you cannot. The only thing that SSIS can do for you is to transfer a report object from one server to another. It cannot run that report.

    The closest thing to SSIS are the distribution services that are part of SSRS itself.

  • June 4, 2012 at 2:39 pm

    #1496771

    Revenant (6/4/2012)

    No, you cannot. The only thing that SSIS can do for you is to transfer a report object from one server to another. It cannot run that report.

    The closest thing to SSIS are the distribution services that are part of SSRS itself.

    Thanks, this is what exactly i want. Thank you

  • June 5, 2012 at 8:21 am

    #1497077

    If you have a report subscription, you can execute that subscription on demand using SQL. If you want, you can do the same thing using the Execute SQL Task in SSIS

  • June 5, 2012 at 8:44 am

    #1497094

    Daniel Bowlin (6/5/2012)

    If you have a report subscription, you can execute that subscription on demand using SQL. If you want, you can do the same thing using the Execute SQL Task in SSIS

    Please let me know how to do with Execute SQL Task in SSIS?

Viewing 9 posts - 1 through 8 (of 8 total)

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