Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Report Server destination Expand / Collapse
Author
Message
Posted Thursday, January 24, 2013 5:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:12 AM
Points: 22, Visits: 192
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).
Post #1411073
Posted Thursday, January 24, 2013 6:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:21 AM
Points: 1,234, Visits: 1,271
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
Post #1411118
Posted Thursday, January 24, 2013 8:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:12 AM
Points: 22, Visits: 192
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?

Post #1411187
Posted Thursday, January 24, 2013 11:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 5,316, Visits: 12,345
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.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1411270
Posted Tuesday, January 29, 2013 6:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:12 AM
Points: 22, Visits: 192
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.

Post #1413001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse