Hi thanks a lot for your valuable inputs...

I still have doubts about BEST PRACTICES...

I mean I say that we can use NOLOCK, we can ue select queries in OLE SRC, and we avoid using AGGREGATE and SORT transformation...

but except this I dont get any other point to say...Is there any other point that I am missing.....

Thanks a lot........