While Exporting to oracle a small issue using ssis

  • I have a column name in which i have names in this way ...

    abc^^ ---actually i had tm instead of ^^

    but when i am exporting it to oracle it loads as

    abc? this way ...so can u plz help me out how load it correctly i am using ansi latin1 1252.....plz urgent

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • is the text in the source column held as unicode?

    tom

    Life: it twists and turns like a twisty turny thing

  • yes tom its unicode but i converted it to to dt_str from dt_wstr using data conversion....but still i have the same problem ..could u plz let me know that ...

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • can you not keep it as unicode all the way through to oracle?

    Life: it twists and turns like a twisty turny thing

  • No I cant it throws error

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply