Problem importing text file into Oracle

[i***@yahoo.com]

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?

[Todd C]

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

Post by i***@yahoo.com
I am trying to use SSIS to import a text file into an Oracle
"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?
.

[i***@yahoo.com]

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?

Post by Todd C
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

Post by i***@yahoo.com
I am trying to use SSIS to import a text file into an Oracle
"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?
.

[Todd C]

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

Post by i***@yahoo.com
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?

Post by Todd C
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

Post by i***@yahoo.com
I am trying to use SSIS to import a text file into an Oracle
"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?
.

.

[i***@yahoo.com]

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)))

Post by Todd C
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

Post by i***@yahoo.com
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?

Post by Todd C
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

Post by i***@yahoo.com
I am trying to use SSIS to import a text file into an Oracle
"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?
.

.