I use Oracle DB (ODBC73 v2.5; system DSN) as a source connection and MSSQL
server as a destination connection. When I run the package manualy, it
finishes without error. I only have problem when package runs on a schedule
basis.
I found this in package log:Specified driver could not be loaded due to
system error 126 (Oracle73 Ver2.5).
I add C:\OracleInstDir\ODBC250 and C:\OracleInstDir\ODBC250\system32 to path
(system variable) but it didn't help. Do I have to restart the computer after
adding both locations to path?