I am using Visual studio 2019 to create SSIS package.
Since I want to do a data flow and I want to use the SSIS Import and export wizard so that it creates the destination table easily.
But when I chose data source oracle provider for OLE DB, it gives me the error below, is it some bug that the wizard not work with oracle provider for oleDB? I had the oracle driver client installed.
And if I manually create a data source using same driver, there is no error.
But for my purpose I want to use the wizard to achieve the result. any ideas why this error?
TITLE: SQL Server Import and Export Wizard
The operation could not be completed.
ORA-12560: TNS:protocol adapter error (OraOLEDB)