Luis Cazares (10/30/2013)
I wasn't saying that stored procedures save a log automatically, but are a simple way to manage your T-SQL code without touching the SSIS packages.For the error logging, take a look at TRY...CATCH documentation. It might seem to be more work to do, but it's more flexible than normal logging.
Sorry I miss understood your prior post. I'll keep the TRY..Catch in mind, but with thousands of individual SQL jobs out there it would be a long time to migrate to that. I was just hoping there was something out there that I wasn't aware of. Thanks.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.