You can design your SSIS packages in various ways, but you should always keep your goals and other factors in mind The other night, I gave a presentation on SSIS architecture to a local user group, ...