title: Date data from Text file to date time in SQL Server
body: <p>I am using one flat file as source which have couple of columns belong to Date format and I have placed all the data into the SQL Server table which predefined.</p>
  
  <p>Example:-</p>
  
  <p>Flat file</p>
  
  <pre>CaseNO|CaseType|CDate
  1     |ORG     |1\12\2012
  2     |PGD     |3\3\2011
  </pre>
  
  <p>here when I check it with data viewer, Its looks like 2012-12-1 00:00:00.0000000. but the OLE DB connection creates the following errors.</p>
  
  <pre><code>[OLE DB Destination [7546]] Error: There was an error with input column 
  "CDate" (8799) on input "OLE DB Destination Input" (7559). The column status
  returned was: "The value could not be converted because of a potential loss of data.".
  </code></pre>
  
  <p>Please guide me...Appreciated your help.</p>
  
  <p>343</p>