Home Forums SQL Server 2008 Working with Oracle Making SSIS work for extraction from Oracle11g to Sql Server 2008 on a 64bit server. RE: Making SSIS work for extraction from Oracle11g to Sql Server 2008 on a 64bit server.

  • September 5, 2013 at 6:17 am

    #1647672

    ashiyana14 (9/4/2013)

    - Have verified I can connect to the oracle dbs from the server using sql plus

    Have you verified both 32 and 64 bit SQL*Plus?

    The SQL Server Agent running the job is 64 bit. Have you tried checking the Use 32 bit runtime option?