SSRS Report Server destination

  • Is it possible to use the Reporting Services Report server as a SSIS destination?

    In the SSRS Report manager it's possible to upload files (with the Upload File button), like csv files, but I would like to generate files in SSIS and store it on the Report Server (in addition to the regular SSRS reports).

  • Let me restate to see if I understand:

    It sounds like you're asking if you can use SSIS to take data from your source and transform/convert it into a flat file. This flat file is then used as a datasource by a SSRS report.

    If that is what you're asking, then you should be able to. The limitation would be the SSRS connection types. So you may want to have your SSIS write out to a .xml file which the SSRS report can use for its data source.

    HTH,

    Rob

  • Not as a SSRS datasource, just store physical files (.csv's or .xlsx's) on the SSRS Report Server in addition to the .rdl reports. When I manually upload a file to the Report Server the online storage address is like:

    http://servername/Reports/Pages/Resource.aspx?ItemPath=/Foldername/filename.csv

    Is it possible to connect to this online folder from SSIS and store data flow results there?

  • I imagine so.

    At worst, SSIS can create the file locally and then you can use a Script Task with whatever C# code is required to achieve this.

    But never tried - seems like an unusual requirement.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • I'm sorry but "a Script Task with whatever C# code" is not really helping...

    I would be surprised if nobody else would want to automate the SSRS feature to upload additional files to the report environment.

    I found out that there's a ReportingService2005.CreateResource method existing which might be useful here, so will give that one a try in a SSIS scripttask.

Viewing 5 posts - 1 through 4 (of 4 total)

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