SSRS Report Server destination

Question

SSRS Report Server destination

ss_nl

Say Hey Kid

Points: 666
More actions
January 24, 2013 at 5:14 am

#269462

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).

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

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

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 1

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

ss_nl Say Hey Kid Points: 666 More actions · Answer 2

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?

Phil Parkin SSC Guru Points: 246964 More actions · Answer 3

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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

ss_nl Say Hey Kid Points: 666 More actions · Answer 4

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.