Home Forums SQL Server 2008 Working with Oracle Oracle's OLEDB Provider VS Microsoft OLEDB Provider for Oracle in SSIS RE: Oracle's OLEDB Provider VS Microsoft OLEDB Provider for Oracle in SSIS

  • July 4, 2012 at 2:18 pm

    #1508870

    Jan.Sundbye (7/3/2012)

    If my memory serves me right I think you need both 32- and 64-bit Oracle Client. If you're using BIDS (32-bit)you need 32-bit client to connect to the Oracle database. And a 64-bit client if SSIS is executed by SQL Server Agent (if you're running 64-bit SQL Server).

    Thanks. Do you have a reference to support this?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/