title: SSIS Convert NVARCHAR to Int
body: <p>I need a solution to convert list of nvarchar to int (or numerical).</p>
  
  <p>Input number is range of 0-10 or null and its a null value not null string.</p>
  
  <p>On SSIS I have an OLE DB Source with this information which is then passed into a data conversion where this field is alterd to numeric (DT_NUMERIC), the destination table is set to receive an int however I always get the below error</p>
  
  <p><em>"Data conversion failed while converting column Range to column numRange.The value could not be converted because of a potential loss of data"</em></p>
  
  <p>I can ignore this and everything seems to work fine but I would rather either handle the error or figure out what's causing it, with this input data what is the issue?</p>