Post reply

Test connection succesfull with Import Export Wizard but fails in BIDS 2012 - Oracle to SQL

  • March 14, 2013 at 1:17 pm

    #271657

    Hello All,

    Test connection succesfull with Import Export Wizard but fails in SSIS Pkg in BIDS 2012

    Can you please help me in debugging this issue. Attached screenshot of error in SQL 2012

  • March 14, 2013 at 5:01 pm

    #1597293

    Help Please!

  • March 15, 2013 at 5:07 am

    #1597426

    What type of connection are you trying to make?

    Just to a SQL 2012 server?

  • March 15, 2013 at 7:31 am

    #1597487

    Do you have the 32-bit Oracle providers installed?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 15, 2013 at 8:01 am

    #1597505

    Ah yeah should have read the title...likely to be a driver issue if trying to connect to/from Oracle.

    May be path related, tnsnames related or driver related.

    Check those first and you should be on the right path.

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

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