I am in the process of setting up a new SQL server 2019 standard edition. (due to price unable to go to enterprise edition) The issue I am having is I have re-written a SSIS package that uses an oracle connector within the package to push data into my SQL server tables.
However when I run this in SSMS it returns an obvious error:
I have also tried to run this via CMD line however returns the same error.
My query is there a way for me to auto extract data from an oracle DB using SQL server 2019 Standard edition.
Due to license restriction we are unable to have VS installed on the server.
Any ideas would be much appreciated.
TIA