SSIS error Extract data from Oracle to Server DB

[Joe K.]

I have an linked server between and Oracle (OLE DB) and SQL Server 2005
database.

When I try to insert data into SQL Server table I received the error listed
below.

Please help me resolve this error.

Thank You,


Source: Select data from Oracle insert into SQL Server Source - Oracle [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNE...

[Todd C]

Hello Joe:
With SSIS, you don't need to use the Linked server in SQL. You can create a
Connection Manager in your SSIS package that uses the Oracle client and hooks
directly into that server (with proper login and password, of course).

HTH
=====
Todd C

Post by Joe K.
I have an linked server between and Oracle (OLE DB) and SQL Server 2005
database.
When I try to insert data into SQL Server table I received the error listed
below.
Please help me resolve this error.
Thank You,
Source: Select data from Oracle insert into SQL Server Source - Oracle [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNE...

[smartin]

Hi,

I am a noob here so apologies if this question is simplistic and/or not
worded correctly.

This thread captured my attention as I am trying to move ad-hoc query
data from Oracle to SQL. I can do it with OLE DB but numeric fields lose
precision in the process (decimal data is truncated to integer).

So, your idea looks interesting. I was able to create a connection
manager to Oracle as you suggested, and write a little query. But I do
not understand how to incorporate this in my data flow package. Any
pointers for the noob?

I am using Visual Studio/SSIS 2005.

Many thanks.

Post by Todd C
With SSIS, you don't need to use the Linked server in SQL. You can create a
Connection Manager in your SSIS package that uses the Oracle client and hooks
directly into that server (with proper login and password, of course).
HTH
=====
Todd C

Post by Joe K.
I have an linked server between and Oracle (OLE DB) and SQL Server 2005
database.
When I try to insert data into SQL Server table I received the error listed
below.
Please help me resolve this error.
Thank You,
Source: Select data from Oracle insert into SQL Server Source - Oracle [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNE...

[JPaul]

Post by Todd C
With SSIS, you don't need to use the Linked server in SQL. You can create a
Connection Manager in your SSIS package that uses the Oracle client and hooks
directly into that server (with proper login and password, of course).
HTH
=====
Todd C

Post by Joe K.
I have an linked server between and Oracle (OLE DB) and SQL Server 2005
database.
When I try to insert data into SQL Server table I received the error listed
below.
Please help me resolve this error.
Thank You,
Source: Select data from Oracle insert into SQL Server Source - Oracle [1]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNE...