title: SSIS task integer not redirect from varchar column as bad data
body: <p><a href="https://i.stack.imgur.com/vqKrR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vqKrR.png" alt="enter image description here"></a></p>
  
  <p>I am doing SSIS Error Handling.
  In excel file source have four columns id,name,department,salary.
  Id and salary (integer column are fine detect varchar datatype and redirect into bad data entry) but name and department(varchar column consider integer and string both values in good data table)?</p>
  
  <p>We want redirect integer values from name and department column to bad data entry </p>
  
  <p>In data conversion transformation configure error output tab to "Redirect" all four rows.Integer datatype (Id and Salary) working fine throw var-char value into bad data table but Va-char datatype column (Name and department) do not throw integer value into bad data table .</p>
  
  <p><a href="https://i.stack.imgur.com/VfGM9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VfGM9.png" alt="enter image description here"></a></p>
  
  <p>Could any one please help me this issue?</p>
  
  <p><a href="https://i.stack.imgur.com/okOlK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/okOlK.png" alt="enter image description here"></a></p>