Sorry for this demanding qns. What are the steps needed to achieve this? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sorry for this demanding qns. What are the steps needed to achieve this?

Hi everyone,
I am new to this forum and new to SSIS. Just pick that up a few days ago… Honestly this is the second forum i joined for this same qns, got no solutions yet:( I am introduced to SSIS to do ETL for repporting in SSRS very recently. I am given a task to analyse employees working hours and pattern through the use of data gathered from access point. I have done something similar to do with QlikView(through use of several sql statements and residents table) however SSIS is totally a stranger to me. I do not uds how i can achieve what this using SSIS. Cant even get the logic and work flow. I need some serious help here. The first table is somewhat my source table data:

EVENT.PNG

This is what i want to achieve, my target table:

EVEMT_TARGET.PNG

Assumptions:
If there are multiple access for one exit, take the earliest access date and time. If there are multiple exit for an access, take the latest exit date time. Not able to take earliest access or latest exit base on the date itself as some legit access maybe during late evenings and some exits may be early in the morning. Secondly, for those accesses with no exit or exit with any access, do not include it in first.

I know many will feel i am asking alot over here, i do agree but i really need serious help. I need to know some of the steps to achieve this. Even guidelines will do. For those who know how, and willing to help please give some advice.

Greatly appreciate any help given.
Thanks,
10e5x
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |