sql server - SSIS Check date format with conditional split -

i have flat file "date" column. problem date come in as

01-jan-16 or

01jan2016 

if run in derived column

(dt_dbdate)(substring(bene_dob,1,2) + "-" + substring(bene_dob,3,3) + "-" + substring(bene_dob,7,4)) 

it handles second date fine, screws first date.

i'm trying deal thru conditional split, i'm not sure how proceed.

how verify date format in conditional split?

or if have alternative suggestion, i'm open ideas.

thanks

replace dashes empty string before derived column rows have same format (01jan2016). you'll need add first 2 digits of year if missing.

or if want use conditional split, test presence of hyphen character , split based on whether in string or not.