In SSIS OLEDB destination component, set load type to table or view - fast load;
there will be options made available, including rows per batch and maximum insert commit size. set these to circa 10.000 to begin with and increase or decrease according to the speed required and amount of ram available.
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”