0 Replies Latest reply: Mar 29, 2012 1:52 AM by user11156570 RSS

    SSIS with ORACLE 10g

    user11156570
      Hi Experts

      I have a problem when i import data from Oracle 10g to SQL Server it shows me error
      *"TEST CONNECTION FAILED BECAUSE OF AN ERROR IN INITIALIZING PROVIDER . CONNECTION NOT OPEN"*

      My Softwares and OS are:

      OS Windows 7 64bit
      Oracle 10g [Full] 32 bit
      SQL SERVER 2008 [248 MB SETUP] 64 bit

      Please help me to resolve this issue.