title: SSIS loading data error
body: <p>I have a CSV file which contains this data:</p>
  
  <pre><code>EmployeeCode,EmployeeName,EmployeeSalary,Date
  101,raju,1000,2/2/2003
  102,krish,100,3/4/2005
  103,rishbh,320,12/9/2007
  104,rani,4690,12/8/2008
  105,olesia,2000,17/4/2009
  106,olga,2000,12/6/2010
  107,mellisa,3330,12/4/2011
  </code></pre>
  
  <p>And I have table called employees:</p>
  
  <pre><code>EmployeeCode nvarchar(50)
  EmployeeName nvarchar(50)
  EmployeeSalary money
  Date datetime
  </code></pre>
  
  <p>When I try to load this CSV file into my table using the SSIS package it gives me an error</p>
  
  <blockquote>
    <p>1) [ADO NET Destination [2]] Error: An exception has occurred during
    data insertion, the message returned from the provider is: The given
    value of type String from the data source cannot be converted to type
    date of the specified target column.</p>
    
    <p>2) [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. 
    The ProcessInput method on component "ADO NET Destination" (2) failed
    with error code 0xC020844B while processing input "ADO NET Destination
    Input" (9). The identified component returned an error from the
    ProcessInput method. The error is specific to the component, but the
    error is fatal and will cause the Data Flow task to stop running. 
    There may be error messages posted before this with more information
    about the failure.</p>
  </blockquote>
  
  <p>However If I remove date column from the CSV and try to insert everything works well. What is wrong with date column, why is it not taking the values?</p>