XML columns Data conversion from SQL to Oracle using SSIS

• kavali.ongole

  Old Hand

  Points: 320

  More actions

  June 23, 2010 at 10:49 pm

  #140957

  Hi

  I have done data conversion using SSIS package from SQL to Oralce and observed oracle data and found that the SQL XML columns are storing some special character '¿' before the xml column beginning in oracle.

  Please help me how to avoid special character in oracle.

  Thanks

  Surendra

• Kari Suresh

  Hall of Fame

  Points: 3712

  More actions

  June 28, 2010 at 7:02 am

  #1185693

  Please check these links might solve your issue:

  http://msdn.microsoft.com/en-us/library/ms141704%28SQL.90%29.aspx

  http://technet.microsoft.com/en-us/library/cc721270%28SQL.100%29.aspx

  KSB
  -----------------------------
  Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha