This didn't work. The difference of RowID between each records shouldn't exceed more than 8. In other words, a record from each group should output sequentially.

Thanks a lot Evil. I think that works.

No, we don't have shift identifier.

OK. What if employee's shift starts around 11PM and goes all the way till next morning. How would that change the query?

Ran the first one and got the result I was expecting. Since, you mentioned 2nd one was effecient, I will use the second one. Thanks again!!!

Yep. Thats it. Thanks for your help.

Those days employee logged in but didn't logout.

Not quiet. Here, on 2/1, employee 234 didn't logout. So, it should just return 234, 2012/02/01, 'Din't LogOut'. This query is returning all other records but LogOut. I...

Question is find out all the records for an employee where he didn't log out on a certain day.

If they forget to Logout, there won't be LogOut records. Or No record for the employee for that day with LogOut jobfunction. I have attached the sample data.

FailePakcageOnFailure is set to False. But this propoerty cannot be changed.

Yes it has serveral task and one task is failing due to date conversion but package contiue to run all other steps.

Its very similar to what you posted earlier.

STEP_____OnSuccess_____OnFailure

step 1____GoToNext______GoToStep3

step 2____GoToNext______GoToStep3

step 3____Notify Failure____QuitFailure

Step 1 is SSIS. The norm would be once SSIS fails, the job should fail and go to step...

Yes. Thats exactly is. Like I said, MaximumErrorCount is set to 1. Does this have any impact?

MaximumErrorCount was set to 0. Does this have any impact?