error handling - Possible to Have Multiple Try/Catch Blocks Within Each Other in a SSIS Script? -
i have project i'm working on , wanted double check before going through work of coding , testing if possible. i'm attempting along lines of:
try { // stuff try { // other stuff } catch { // fail silently } // more stuff } catch (...) { // process error }
is possible have try/catch's within try/catch's? languages allow when attempted search web not, life of me, find answers.
thanks
an ssis script task c# (or vb.net). c# allows this, ergo ssis allows this.
having written few ssis script tasks in time, i'd encourage take advantage of raising events in script task.
depending on version + deployment model + invocation method, might want turn on native ssis logging. project deployment model (in 2012+) provides native logging. otherwise, need specify events you'd log logging provider(s) you'd use them. need done part of package development. otherwise, dtexec call /rep ewi
ensure errors, warnings , information events logged console/sql agent.
Comments
Post a Comment