thanks john, well seems to be that i dont have permission to start msdtc services, i will figure out later on, now i have one more question, on the same...

thanks but how do i run msdtc in my local machine, its just client machine with BI installed.

Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur...

sorry forget to a attach the file

this screnshot is of control flow with condition<=50 with required option on data flow and supported option in control flow.

thanks

first one is required and second one is supported and both are exeucted with <=50 condition.

here I have attached screnshot with both option and the condition is <=50, the first screnshot is with required option and the 2nd one is with supported option.

thanks

John I was busy with my other ssis task and i am really sorry for the late response, so i created data viewer with both option 'supported' and 'required'. In...

Yes John you are right when I tested with 495 errors, remaining 5 good records were supposed to inserted on destination table, but instead the package failed. Now how do...

Yes john i need to fail a package if there are more than 50 errors, means >50 upto 50 package should not fail. here I have attached 2 screnhot it...

John let me explain you, as you know i have 5 good records out of 500, and i set a condition <=50, so chaging transaction level to required it will...

john thanks for your response, i changed the transaction level to required at my data flow, but in this case package will fail in both condition either 50. as...

John I am assuming the other method also, you know pretty much about .net code. on event handlers, i am creating a scrip task and try to run this .net...

do i need to create a transaction on event handler? what i am doing is that, in event handler under executable i choose an option data flow...

ya I got you john, now how do i configure error handling in my oledb destination? can you please explain me in detail. greatly appriciated,