August 10, 2020 at 10:12 pm
Trying to connect oracle destination but no luck. Has anyone connecting Oracle in SSIS using VS 2017? Please advise?
August 10, 2020 at 10:32 pm
I used Oracle ODAC from https://www.oracle.com/database/technologies/odac-downloads.html. 64bit on 64-bit sql server box is enough; to debug, you also need 32bit since VS2017 is 32bit only.
August 10, 2020 at 11:12 pm
if you have Enterprise Edition use the Attunity driver instead as it is faster - you still need oracle client.
if you have SQL 2019 then the newer driver will be better - all available on same link https://docs.microsoft.com/en-us/sql/integration-services/attunity-connectors?view=sql-server-ver15
August 13, 2020 at 11:39 pm
Thanks. After installing the Oracle ODAC I can able to successfully create ODBC however from Integration service I get the error ODBC connection manager "Test connection failed because of error in initializing provider. ERROR ODBC driver manager the specified DSN contains an architecture mismatch between the driver and application". Please advise?
August 14, 2020 at 10:33 am
on your pc you need both 32bit and 64bit of the oracle client as you were told before.
32bit install should be done first.
Did you do that?
August 14, 2020 at 10:26 pm
Thanks it worked. Regarding Attunity driver will it show up on SSIS tool box after the install?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply