How about people that just implement missing index recommendations that create a nonclustered index that is a covering index and recreates the entire table?  Yes, I found one...

Ranting: Just noticed that you said your company recently upgrated to SQL 2012 - WHY!! at this point in time they should have gone to 2016 or 2017.

A bit of...

your idea of copying to SQL will work and in some cases could be the best option.

Is the table in Oracle updated outside this SSIS process? If not then you...

memory available is normally based on number of processors, not cores as far as I know.

and depending on the processor model memory on this model can be higher than the...

also

Site slow when going through the latest topics, both initial page and next pages.

Layout / colour schema quite annoying. Lost one post already because of the fact that existing /...

If your users can be without the db for some time it might be a better option to get a bigger drive with potential to expand at a later stage,...

that option has nothing to do with the source but only with the destination.

You need to check if you have the Enterprise edition - if so you can and should...

you got SQL Enterprise or other?

Is this incremental or full load? if incremental how do you deternime inserts/update/deletes?

and how exactly are you extracting the data - oledb, ado.net, odbc?

and is...

You stated that currently reports of that table are disabled.
And also that updates/deletes are not done at all - being insert only makes it a bit easier.

and exactly how are you trying to load and what are the errors you are getting?

And what have you tried to fix the errors you are getting?

fact that the database engine allows it at a lower edition does not mean that the Integration Services does.

See Integration Services features supported by the editions of SQL...

Netezza optimization is a bit different than other db's.

I did find this article Analyze and Optimize Netezza Query Performance[/url] which is probably worthwhile reading