Home Forums Data Warehousing Integration Services Using SSIS 2012 to read data from Oracle 11g R2 RE: Using SSIS 2012 to read data from Oracle 11g R2

  • September 5, 2013 at 4:57 am

    #1647651

    pmscorca (9/5/2013)

    Hi Koen, thanks for your reply.

    SSIS 2012 runs on a db server with SQL Server 2012 64-bit and Windows Server 2012 64-bit: however do I need to install also the 32-bit Oracle client?

    After the installation, inside the Oracle data provider is it enough to specify the server name, the user and the pwd to access the Oracle db?

    Thanks

    You only need to install 32-bit components on the machine where the SSIS projects will be developed.

    Regarding the connection: you'll also need to configure the TNSNAMES. You better ask about that in an Oracle forum 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP