MicrosoftMy environment:
- VS2019, v.16.4.6
- SSIS Integration Services Projects for VS2019, 15.0.2000.94
- Microsoft Connector for Oracle, v.2019.150.2000.110 (both editions 32-bit and 64-bit)
- MS SQL Server is NOT installed on my machine
- Oracle Client is NOT installed on my machine
SSIS project settings:
- SSIS Project, Run64BitRuntime is set to False
- DelayValidation setting is set to True for
- Entire package
- Data Flow
- Oracle connection
- Package ProtectionLevel is DontSaveSensitive
It seems that this particular setting is a culprit...
Oracle Connection:
- TNS service name is in the [//]host[:port][/service_name] format
- Using Oracle Authentication, i.e. user name and password.
'Test Connection" button gives "Test connection succeeded."
Oracle Source Editor:
Data Access mode: Table Name, and I can see all the tables in the Oracle database.
I selected a tiny table with 10 rows total.
Clicking upon "Preview..." button shows me all the rows from Oracle table.
Package Execution
Everything looks good, but executing package in VS2019 errors out with the following output:
SSIS package "~\...\OracleConnection.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC0014009 at Package1: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
Error: 0xC020801C at Data Flow Task, Oracle Source [5]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The
AcquireConnection method call to the connection manager "CAS" failed with error code 0xC0014009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: Oracle Source failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
Warning: 0x80019002 at Package1: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "~\...\OracleConnection.dtsx" finished: Failure.
The program '[18744] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).
