January 12, 2009 at 9:11 am
I am a new user of SQL Server Business Intelligence. I would like to know how to include an Integration services package in a Reporting Services project in order to update a data warehouse before reporting on it.
January 12, 2009 at 1:29 pm
So do you actually want to use the SSIS package as the source of the SSRS report? If you are looking for information about that you can look at the following links for information about that setup:
Using a parameterized SSIS package as a data source for SQL Reporting Services
Configuring Reporting Services to Use SSIS Package Data
I have a couple screenshots on setting up the package and the SSRS dataset here:
Using Reporting Services (SSRS) with SSAS data
If you are going to kick off the whole ETL and SSAS processing prior to this then you might want to setup a table to evaluate to determine if the data warehouse has been refreshed that you can evaluate or at least that contains the last update date/time that you can display on the report for the end user. I wouldn't want them to wait for the entire load process was completed in order to view the report.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
January 12, 2009 at 1:31 pm
Reporting services and SSIS are two distinct things, two different services.
You can't do this, and I'm not exacly sure why you would want to.
Reporting services only cares about datasets, and as long as the Data set is available then it can run.
To Require your Dataset to be ready before reporting on it, is not a "Standard" Feature. You will have to build your SSIS Package in BIDS (Business Intelligence Dev Studio) Separately.
Hope this helps.
Post more information if you would like additional help.
January 13, 2009 at 9:37 am
Thankyou for your prompt and helpful advice.
Chris
January 13, 2009 at 9:39 am
Thankyou for your timely and detailed response. It was just what I needed to know.
Chris
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply