Hi, I have a source table with nearly 97,000,000 rows which I want to insert into a destination table. I am using Microsoft SQL Server in my job I use tMSSqlInput to get the source which is wired directly to a tMSSqlOutput to output to the destination table. The job takes ages but the SSIS job which I am replacing runs in around a minute. I there a more efficient way of doing this? Thank, Dave.