I am running an SSIS package and boss has given me the task to enter the age based on the day package has run. The age column will be valid at the time of the transaction and that is what they are looking for.
–
AsgharOct 26 '12 at 14:37

There are very rare cases that you need to store items such as age. Since age changes daily, you will have to update your records often. It is instead better to store a fixed value, such as the date of birth that can be calculated. Most DBMS's provide the functionality for doing the date arithmetic for this reason.