Hi,

thanks for the reply.

Could you pls make it clear more...is that a Dataflow property wt you are saying? ,cos i couldnt see any option in it & if you are saying abt the Lock what we are specifying in the OLEDB source, then that is not selected. and here i am using Nolock keyword for all my select stmts. I am using OLEDB command to do Update, Insert & DEL. and its getting locked in a particular table Insert.