This discussion is archived
0 Replies Latest reply: Mar 28, 2012 11:52 PM by user11156570 RSS

SSIS with ORACLE 10g

user11156570 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points