I am trying to use SSIS to import a text file into an Oracle
database. However, I get the following error:

"Test connection failed because of an error in initializing provider.
Oracle client and networkinig components were not found."

However, I do have the Oracle client and networking components
installed. In addition, I have the OraOLEDB.Oracle provider available
under Linked Servers in SSMS. Has anyone else come across this
problem?

Hello.
I assume that you set up your Destination in the Data Flow to point to a
Connection Manager that uses the OraOLEDB provider? You are supplying a
username and password for that connection, and you can test the connection
yes?

Is it failing when you run it from a server? Cab you give us more details
about the environment and connections?

--
Todd C
MCTS SQL Server 2005


"imani_technology_spam (AT) yahoo (DOT) com" wrote:

The OraOLEDB provider is 32-bit, while the version of SSIS 2005 we are
using is 64-bit, running on top of Windows Server 2003 64-bit. Would
that be a problem?


Jan 25, 4:15*am, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:

It's possible. I'm not that up on 32 vs 64 bit processing. I think there's a
switch somewhere that flips SSIS to 32 bit.
--
Todd C
MCTS SQL Server 2005


"imani_technology_spam (AT) yahoo (DOT) com" wrote:

We successfully used the Oracle Provider for OLE DB to create a linked
server in SQL Server. I assume that proves that the provider does
work. However, I have no idea how to implement this connection for
SSIS. Here are the parameters we used to create the linked server
that I would like to use to create a connection in SSIS:

Provider: Oracle Provider for OLE DB
Product Name: Oracle
Data Source:
(DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= anadev10)(Port= 1563))
(CONNECT_DATA = (SID = devetl)))


On Jan 28, 6:08*am, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote: