SSIS Check date format with conditional split
<p>I have a flat file that with a "date" column. The problem is that date could come in as</p>

<p><code>01-Jan-16</code> or</p>

<pre><code>01Jan2016
</code></pre>

<p>If I run this in a derived column</p>

<pre><code>(DT_DBDATE)(SUBSTRING(bene_dob,1,2) + "-" + SUBSTRING(bene_dob,3,3) + "-" + SUBSTRING(bene_dob,7,4))
</code></pre>

<p>it handles the second date fine, but really screws up the first date.</p>

<p>I'm trying to deal with this thru a conditional split, but I'm not sure how to proceed.</p>

<p>How do I verify that date format in a conditional split?</p>

<p>Or if you have an alternative suggestion, I'm open to ideas.</p>

<p>Thanks</p>