May 13, 2012 at 4:14 pm
I have seen various strategies with respect to error handling in SSIS Packages.
I have a lot of packages and a significant number of tasks that I need to incorporate error handling.
Any straight forward ideas or suggestions would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 14, 2012 at 12:05 pm
I like the ideas that Andy Leonard has incorporated into his SSIS framework and have rolled these into my package design templates. He uses a parent package to loop through and run all of the child packages. All of the package progress/status and error logging is done at the parent.
This may (or may not) help depending how your current packages are setup, but it's worth looking at to get some ideas.
Andy's original framework posting:
http://sqlblog.com/blogs/andy_leonard/archive/2011/09/16/designing-an-ssis-framework.aspx
I think the latest can be found at:
HTH,
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply