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

O-B (orenb70 (AT) gmail (DOT) com) writes:
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, esquel (AT) sommarskog (DOT) 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

O-B wrote:
Contact Oracle about Heterogeneous Services.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

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: