• 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?

    THanks