Get Value from Oracle Function in SSIS

%3CLINGO-SUB%20id%3D%22lingo-sub-1292387%22%20slang%3D%22en-US%22%3EGet%20Value%20from%20Oracle%20Function%20in%20SSIS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1292387%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20under%20the%20situation%20that%20I%20should%20get%20all%20the%20values%20from%20Oracle%20query%20that%20includes%20user-defined%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfterwards%2C%20I%20have%20to%20load%20the%20result%20into%20SQL%20server%20table.%3C%2FP%3E%3CP%3EPlease%20give%20any%20advice%20or%20idea%20to%20solve%20this.%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1292387%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntegration%20Services(SSIS)%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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.

0 Replies