Pulling 500,000 records from SQL Server DB per day

Hi,
from SP read all data and store in File in some server. Read file how ever you like. Here, DB hit is only once per day.

Thanks,