I have a case where I am using SSIS to insert records and I a leaving out a timestamp column which has a default constraint of getdate(), strangely, when I run the insert, the column is still NULL.