Small work.
Issue in oracle database integration unable to solve it because of lack of knowledge in SSIS.
should be like 10 mins work for experts.
Recently Domain of BI server was modified then we started to have this issue.
I don't know the username and password of userID used in scheduled job, wanted to make it work again.