churlbut (11/23/2010)
My vote is with Da-Zero. Dynamic SQL in Execute SQL tasks. I think these run more efficiently than Data Flow tasks, especially if you will be working with big record sets.
Why is Dynamic SQL in Execute SQL tasks more efficient with big record sets??
Im with Craig...