title: Issues in ssis when converting data types
body: <p>Hi am having trouble understanding data conversion in ssis. when should one convert data types,should I always convert or I only convert when ssis has data type compatibility issues?</p>
  
  <p>Am struggling to understand if i should convert when i import from excel to sql server or from sql server to excel or from text file file to sql server or from sql server to text file etc?</p>
  
  <p>Please help me understanding data conversion in ssis.</p>