Performance Problems - curious problem

Hi people !

I am facing a curious problem. I have this Job and one of its transformation is a tr that i input a database and perform some lookup steps to take values, and them i set some variables and to finish i write in an output step.

The curiosity about it is that this transformation runs without problems in other 2 envs but in my is taking more than 24 hours !
I just check mem configs, db configs, but when i analyze those DB activies i see a lot IDLE selects and i dont know what can be.

I thougth that maybe someone could just had this problem or some tip to give me.

Thanks.

[]'s

Maybe slow network connection?

Mick,

This is not the cause of this problem. I already eliminate this point.
Thanks for the answer, anyway.

[]'s