Conversion of a datetime2 data type to a datetime data type results out-of-range value

This can happen if you do not assign a value to a DateTime field when the field does not accept NULL values.

That fixed it for me!