471,066 Members | 1,376 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

SSIS 64bit to Oracle 10G

O-B
Dose any one have a simple workaround to implement a connection from
SQL 2005 SSIS 64 bit to Oracle 10 G

Mar 4 '07 #1
3 5547
O-B (or*****@gmail.com) writes:
Dose any one have a simple workaround to implement a connection from
SQL 2005 SSIS 64 bit to Oracle 10 G
Never having worked with Oracle, nor with SSIS, I don't really know what
the problem is, but if the problem is that the MSDAORA provider is not
available in 64-bit, you should try either OracleClient in the .Net
Framework, or get hold of Oracle's own OLE DB provider. Whether the latter
is available in 64-bit, I don't know. But as I understand it MSDAORA is
largely outdated and does not work well with Oracle 10.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 4 '07 #2
O-B wrote:
Dose any one have a simple workaround to implement a connection from
SQL 2005 SSIS 64 bit to Oracle 10 G
Contact Oracle about Heterogeneous Services.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Mar 4 '07 #3
O-B
Thanks to the people that tray to help me.
I have found the solution to that problem.
To work with the SSIS that installed on a Window 2003 64 bit one
should know that the dev studio is an 32 bit application and the
oracle client should be a 32 bit oracle client 10g with the path.
After that you can create the connection to the oracle. If you chose
to work with linked server than you should install the oracle client
64 Bit with the right paths.
-------------------------------------------------------------------------------------------------------------------
O-B wrote:
Dose any one have a simple workaround to implement a connection from
SQL 2005 SSIS 64 bit to Oracle 10 G
Mar 4 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Christian McArdle | last post: by
1 post views Thread by Eric | last post: by
9 posts views Thread by gelangov | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.