Myself and the previous poster thought you were using a data flow task. That would be easiest.

Add a data flow task to the contol page; set up a connection to the oracle database and another for the SQL Server database, add a data source in the data flow. You will probably need a data conversion transformation, and then a destination control to output to the SQL Server table. You will be able to map the input columns to the output table with no need to loop through record sets.