This is the culprit:
TNS:could not resolve the connect identifier specified
Which Oracle client are you using?
Maybe you can ask this question in an Oracle forum, as it's clearly an Oracle issue and not an SSIS one.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP