Thanks, makes sense what you say, I will though then keep the insert into in a SQL Task, as we are adding all the other tables via SSIS, the performance is almost similar for this select, the fast load on the other tables are great though and then big improvement why I keep in in SSIS is cutting out all the other steps, renaming fields, changing data types etc, the run times are roughly similar between SSIS and SQL, but I am working on settings on SSIS which is gradually improving performance on SSIS compared to SQL. Our large Clients ETL's are currently taking about 2-4 weeks, so by adding it to SSIS I can also running different tasks at the same time. I think this is the greatest thing with SSIS at this point unless I can get really increases in performance on SSIS which would be great.

Any extra tips etc would be great on getting performance on SQL and or SSIS. The tables are really huge, one table had 1,800,000,000 rows.

Thanks for the advice, will definitely try implementing as much as possible.