• You'll need to install the Oracle client on the server machine.

    32-bit to be able to develop in SSDT and 64-bit for running the packages on the server.

    Once you install the client and the providers, you'll be able to select the Oracle OLE DB provider from the list when you are creating an OLE DB connection in SSIS.

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