Get Value from Oracle Function in SSIS

Hello experts,

I'm under the situation that I should get all the values from Oracle query that includes user-defined function.

Afterwards, I have to load the result into SQL server table.

Please give any advice or idea to solve this.

Thanks in advance.