SSIS already has a built-in component for sending email. What are the advantages of using a store proc that calls sp_send_dbmail over sending the email directly from the SSIS...
One of the biggest frustrations we've faced is not being able to mash-up two report datasets from different data sources together elegantly. In your scenario at the...
Steve, I agree! It's definitely possible for the developer not to know the data and mix up two elements. In an IT project, however, I'd assume that the...
I agree with your house/Formula One analogies, and I think this has been one of the big, slow realizations in our industry: that we don't get it right the first...