Hi @sydney ,
If I run parent.dtsx via a sql agent job, I get an error saying "ORA-01005: null password given; logon denied".
May I know if the user that to execute the parent.dtsx has full permission to connect to the oracle connection?
May I know if you try to run parent.dtsx in SSDT?
Please try to deploy the ssis packages to SSISDB Catalog and then run the packages in Sql Agent Job from ssisdb catalog.
Please refer to ORA-01005: null password given; logon denied" Error when trying.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.