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

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -