You will have to give atleast Report browser permission to the limited user account in Report manager-> security.

Use lookup...Join on EmployeeId...modify advanced query to something like

select top 1 * from

(select * from [dbo].[Employees]) [refTable]

where [refTable].[Id]< ? Order by Id desc

(there are other...

For this problem, best solution will be to modify sql query

If you still want to go SSIS way, use a Lookup, modify the query in advanced query to get...

Thanks Steve...I'll try this approach...