Thank You, very good advice on that.

Yes, you understand correctly. I would really like the database to not log anything for this data load.

Yes, I had left that to the default value of:

Rows Per Batch = blank

Maximum Insert Commit Size = 2147483647

I am going to change the values, test some more, and see what works the best for that one step. Only one of the tables that I am pumping data from is large, over 1.5 billion rows. All the others are really small in row count.

Thank you Greatly.

Andrew SQLDBA