Here I have attached a file with data viewer just before the conditional split. and condition is <=50

thanks for your response, here I have attached my data flow scren when I execute a package with <=50 condition, since I have 495 errors. at <=50 condition, the package...

any luck john, i am trying my best bu tnot working at all now.

now weird things start happening, package is executing successfully in both condition i.e <=50 and <=500, since I have 495 bad records, my error rowcount variable condition is<=50, in...

ya theres a blocking on the db, and while trying to query the dest table, query is just executing,not completed. so i have to stop debugging to come in the...

here I have attached screnshot for control flow and data flow after creating container and setting container transaction level required and rest of the transaction option would be supported. when...

John did you came up with any new idea, because on top of that i need to add email task also.

its on execute sql task, and when i run a package with transaction option required on control flow, only truncate command will pop up with green and data flow task...

so in my case I need to put transaction option required at control flow? since I have execute task connected with data flow task on control flow. After doing this...

Now what container do I have to use inside contorl flow, as you know I have execute sql task connected with data flow task on control flow. So you mean...

you mean I need to put trancational option 'supported' on data flow and 'required' on control flow.

ohh sorry i thougt u knew, i have truncation part on control flow, when the data loads from source to destination, I need to truncate the dest table first and...

John we wil discuss about email later on, lets go to the second issue, i am giving you an example, every day dat will load from source to dest. Now...

John thanks for your response, I ran msdtc services in my computer and was able to rollback the data with transaction option 'required' but the email task didnt work when...

So you mean I need to choose 'on error' option on event handlers tab and Executable would be 'data flow task' to get an email after i get an error...