Thank you all ! your suggestions really helped.

In my case, same supplier can be in different countries, also different suppliers can use the same Commodity type.

But the data tables...

Thankyou! I think I got it. I will try to create independent dimensions and see how it works.

@snap254 : Thank you very much!

Thank you for the replies!

@ opc.three: This solution worked for me. Thank you. In my case I have a almost 10 columns which make a transaction. So, I am trying...

George,

I do not want to use an undocumented extended stored procedure. I am not sure if that is reliable.

Pradeep,

I tried it earlier. Where the job has like 5 steps and say the 2nd step is running, it gives that the job step 1 has completed successfully. It doesn't...

Hi Leo,

I used SSIS. Thank you for the reply.

Best Regards,

Praveena

Hi Rashmi,

It was logiing twice for the parent package because it actually had 2 errors with in the same task.

Error 1: Cannot open the datafile "S:\DB\xfer\Process\0000_ow_master_12042010_100005.unl1".

Error 2: component...

Hi Rashmi,

That worked for the child package. But, for the parent package, it still shows the same behaviour.

Thank you for your inputs. It helped.

Raunak/Daniel,

In my parent package, the child packages are all executed in a sequence container. And probably that is the reason why it records the error twice, once for the Execute...

Raunak,

I have one error in the parent package and one error in the child package. In that case the handler should be only called once for the parent package and...

I am logging it both in the child package and parent package, ON Error. But the package Names will be different in the rows. And after running the package I...

I did the same. I posted it here to see if I get something better long ago.

Thank you for the response!

Daniel,

Thank you for the response. It is resolved. It was the way I created the report. The report was built to show summarized data, but I had a calculation in...

This is really an urgent requirement.. Could any body suggest a work around..

Thanks in advance!