Hi Eric,

Thank your for your help and comments.

Yes, I metioned above this update takes 45 seconds, reason why this unacceptable is because this is one query of 11 I...

Hi All,

Here is the Actual Execution Plan.

Thanks!

Regards

Rodrigo

Ohhh I see, so sorry my mistake. Here is the Execution Plan.

Thank you for your comments.

Regards

Hi, thank you for your response. I already upload the execution plan and here are the index definition, table definitions are above, please look into my first post.

CREATE NONCLUSTERED INDEX...

Hi,

Thank you for your answer. I already ran package for ten times and results are the same BIDS is faster than DTEXEC.

Regards

Rodrigo

Hi,

Thank you for your question, basically package don't fail, issue is related with duration, when I execute from BIDS is faster than execute using DTEXEC or Job.

Regards