Hi everyone,
my apologies for not being active in this QNA.
I already found the solution.
The issue was, even though I installed adasql.ddl and correct version of ADO.NET in my pc, those library and framework were still missing in our work server (sql server agent Jobs run in our office server).
After DBA installed them in the server side too, the job ran successfully.
I did not use SSISDB but deployed the SSIS package in the SQL Server Agent using the
Type - SQL Server Integration Services Package Package source - File System
Thank you!