title: Load bit data type data from SQL to Numeric data type in Oracle - SSIS
body: <p>Hi,</p>
  <p>I am trying to load data from SQL table which is bit data type for one of the column in to Oracle table where column data type is numeric and all the values of  1 are loading as -1 in Oracle table. Please let me know the solution as I tried to convert but didn't work as expected.</p>
  <p>SQL     Database:- Column Name - Is Load; Data Type: Bit           ; Values- 1,0</p>
  <p>Oracle Database:- Column Name: - IsLoad; Data Type - Numeric; Values - ( Need 1,0 but loading -1 instead of 1 )</p>
  <p>Thanks,
  Sandeep</p>