teareal_1 (11/25/2014)

---

Thanks for the responses! I tried setting it to not cache and made sure I was not using fast load, however, that did not change anything as far as making the package run "row-by-row".

My solution was to dump this whole approach and just write a stored procedure to loop through the data. It is slow but since I am moving away from writing my conversion programs in Visual FoxPro...even if it takes 5 hours to process 7mil records...that's faster than the 4 days the old FoxPro code would take.

Thanks again!