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

This is really the bases of ETL processing.
Following is a standard pattern to load data from staging into one or more destination tables

1 - Load...

I would say its not so much the SQL but the VM and the Host config that matter.

How many CPU's does the Host have and how many are...