• i don't think i understand, in the execute sql task i created the command SELECT MAX(wwoq.StatusChangedOn) AS MaxDate

    FROM wrkWorkOrders AS wwo

    INNER JOIN dbo.wrkWorkOrderQueue AS wwoq ON wwo.WorkOrderQueueId = wwoq.Id

    INNER JOIN dbo.wrkWorkOrderStatuses AS wwos ON wwo.WorkOrderStatusId = wwos.Id

    WHERE wwos.Description = 'Completed - Costing'

    then set the Result set to variable User::MaxDate

    now i want use the oledb source to select * from table where ChangedOn <= User::MaxDate, but i'm not sure how to do that