guoxiang1610 (12/9/2012)
Phil Parkin (12/9/2012)
May I ask how you think that SSIS can help you with this problem?Based on the data provided, it looks like a stored proc would be suffucient to provide the info to the SSRS report.
Hi Phil,
Firstly i want to thank you for replying. Thanks. Oh i am sorry if my way of asking is way too lousy, i am quite new to forums, i will read on the link provided. U mentioned about how can i think SSIS can help me with my problem? actually i am not even sure myself. This task was just throw to me without further guidance and i was just told "study the data and requirement, Use SSIS to perform the etl process and then use SSRS to do a report" I have done a few SSIS tutorials and i realize SSIS always work with data flow. So in order to achieve what i want, how will my flow look like? i know my first step is get alll my date and time fields into correct ssis data type. Then maybe i can do some select bla bla bla from table order by staff name, event_d and event_t... how shall i do this?
You mentioned about stored procedure, can it be done at SSIS or?
Sorry if i sound too noob but i am really confused.
No need to apologise, I can tell that you are trying to get this resolved.
Can you first of all confirm the source of the data - is it a SQL Server table?
If it is (and leaving aside Jeff's comments around the proposed business rules - which also need to be resolved), this not an SSIS problem. What you need is a stored proc - of whatever complexity - which returns the data in the form you have shown. This proc will be your report's data source, simple as that.
If your data is coming from, for example, a text file, we're back in SSIS territory. But in this case, there would be at least two processes involved:
1) A regular SSIS package to import the data into SQL Server
2) One or more SSRS reports which use stored procs, as necessary, to access and present the imported data.