I have a large data file that I am running through SSIS. Very simple `XML source` into a `SQL database`. I seldom use SSIS so I am far from an expert.

I have some records that I push into an error table because the dates are incorrect.

What I want to say is, if the date is not in a date format, then update this `date` to `NULL`.

I don't know if `Derived Column` is the way to go, but it appears it should be given examples I have been reading online. 

I want to fix this issue in the SSIS stage, not in SQL after the data has been loaded in to the error tables.