so here is what I plan to do now:
1. create a Execute SQL task using OLEDB connection ( source SQL server) with select query and full result set.
Set the result set to a varible of objects. and any other columns I need in the following tasks, I also assign them to variable.
2. add a loop container,
3, in 2, I add another execute SQL task with ADO.net connection (Oracle server) for destination.
I am a little confusing now, should I use ADO.net connection for both source and destination (2, 3 above) or should I use OLEDB for 1 and ADO.net for 3?