none
(Sumber: milist SQL Server) ssis ke oracle

    Question

  • dear rekan-rekan,

    saya ingin mengimport data dari server oracle di komputer A ke sql server di komputer B pake ssis 2008 R2 di komputer B. saya suda install oracle XE dan mengatur tnsname.ora nya di komputer B. provider oracle for ole db nya sudah ada, tp pas konek error nya tns not listener. itu kenapa ya? apa ada settingan sql server yg mesti di atur? please sharing nya. saya hanya pernah pake ssis 2008 R2 dan oracle 11G di komputer B dan ini berjalan normal

     


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Friday, January 27, 2012 1:04 PM

Answers

  • cek apa listener nya sudah nyala atau belum.

    cek juga port nya, diset dimana, dan apa sudah dibuka/allow di firewall setting.

    lalu cek apakah driver yg dipakai di server B compatible dgn yg di A.

    last, cek username dan password, apakah terdaftar di A, valid, dan masih aktif

     

    Dijawab oleh: nugon19


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Friday, January 27, 2012 1:05 PM