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