Data dump via SSIS package

This project is for SQL Server 2012. I have a query in which I am running it to pull data daily.. I want to create an SSIS package which will use this query but there has to be a look up table created because the query is pulling needing to pull a min number from previous day and add a +1 and pull the max number for current day then insert that max for current day into lookup table for next day as the min to have a + 1 added the next day's run. The look up table will need to store min, max and company ID so that it can pull it based on company.