title: Date format issue in SSIS package day is converted to year and year is converted to day
body: <p>I am trying to insert a date value in a <code>datetime</code> datatype column of the SQL Server through <code>SSIS</code> package. </p>
  
  <p>In the source *.<code>csv</code> file it is in the format <code>dd-mm-yy</code>. </p>
  
  <p>When I am manually running the SSIS package there is no error. the date format from the .csv file <code>DD-MM-YY</code> is successfully inserted in the SQL server database in <code>DD-MM-YYYY</code> format. </p>
  
  <p>But when I am running the same package through Jobs in SQL Server Agent it gets converted to an incorrect date format because DAY is converted to YEAR and YEAR is converted to DAY.</p>
  
  <p>For example if the date in the .csv file is <code>15-03-13</code> (DD-MM-YY) it gets inserted as <code>13-03-2015</code>. </p>
  
  <p>Tried a lot to get the date in the correct format in the database but all in vain.</p>
  
  <p>Please suggest how to fix this issue.</p>
  
  <p>Thanks in advance.</p>