>The beautiful thing about SSIS is you have pretty much complete programmatic control at every step of the process.
>
>Kevin is the authority here ( I'd recommend his Code Magazine Baker's Dozen article in two parts on SSIS ) . The AppDev course is pretty comprehensive ( $99 for all their stuff for a year ) and Pluralsight ( $29 a month ) has SSIS course as well.
Charles not long ago you gave me the link to Kevin's tutorial on how to do exactly this:
http://www.code-magazine.com/Article.aspx?quickid=1009081
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges