Is it possible to do this is SSIS? I've written a number of other SSIS packages for this project that work successfully and it would be best to keep all...
I'm sorry, but I don't understand the solution. What is SMS? How does this differ from what I am already trying? Perhaps some details would be helpful.