John thanks for your response, i am going thorugh your link, mean while i have attached my control flow and data flow screnshot, can you please tell me where do...

John can you once more help me out to fail over the package with my current requirements. As I mentioned in my earlier email, we wil never know what causes...

well i am testing two tables with two diffrent data types, source table have nvarchar data type and destination table have int data type, i was told to build...

these 495 records are sample data that i am trying to test, and u are right that I need to fail the whole package, the remainig 5 records should not...

john my bad it was case sensetive error, i got it, now your method is running very well, i really appricaiate, now a bit confusion, i have attached my data...

John

I created vareable name 'errorrowcount' and even edited the variable name on the script that u sent me. variable name is correct, now my question, i created variable on...

john

thanks, that parse the .net code, now when I am trying to execute a package I am getting follwoing message

"[Script Component [3513]] Error: System.Runtime.InteropServices.COMException (0xC0010001): The variable cannot be found....

John

thanks for your response, I dont have a knowledge of .net, i added a script component in my data flow, and just paste your code on 'design script' and i...

well i am still waiting for a response to my post!

well guys I have attached an screnshot of my data flow. I have created a variable with rowcount, if an error exceeds more than 50 then the entire packagae should...

well guys I have attached an screnshot of my data flow. I have created a variable with rowcount, if an error exceeds more than 50 then the entire packagae should...

Rupa

Your method is working and even I am stuck on the exceptional handeling, i know we need to add one more oledb tranformation in between conditional split, but have no...

john do i need to create row count variable on conditional split transofrmation?

john

mine is pretty straight forward, I edited oledb destination and set 'error ouput' option to 'redirect error' by default it would be 'fail component' so this 'redirect error' option...

I will appriciate if you can send me the screnshot of the data flow to my question, I am bit confused how to embade row count, derived cloumn and conditional...