With SSIS, we often used to use it to orchestrate T-SQL to do the manipulation, rather than getting SSIS to do the transformation. Databases are good at getting a lot of things done in parallel and in a hurry.
add a skeleton here at some point
about 1 month ago
