Load data from PL/SQL query of Oracle to SQL Server in SSIS

Copper Contributor

Hi, experts,

 

I'm suffering to extract data from Oracle with PL/SQL query and transform the result to load the result into SQL Server.

 

However, I have no idea how to get all return value from PL SQL query and insert into SQL Server in SSIS.

 

Please anyone who knows the steps to achieve let me know.

Thanks in advance.

0 Replies