Thanks, I forgot to say the big picture.

This bad data is from an application that use oralce database. The data type is date in Oralce.

I am wondering how the bad data like that got into the table in the first place.

because 0210 is not a valid year.

I am importing data from oralce to SQL server using SSIS.

I cannot fix it the Oralce side. in SSIS, I got a data conversion failed because overflow error in the source input column.

I am trying to avoid this bad record, not sure if there is a is_date() function in Oracle, then I can use the query in the source to filter them out