In SSIS I select from Oracle into an Object variable using execute SQL task with ADO.Net connection.
I now need to put the results into SQL Server but can't do it per column as my query result has 60 columns. (My test worked but that was only for 5 columns).
The code I have thus far is:
Code:
DataSet set = new DataSet();