Yes other process run same time.

It fetch arround 1 milion records

Connecting to link server is by a user & user has admin rights. Thing is same package works fine when...

Thanks for the reply.

Yes, package running fine when i run manually only sql server agent is issue. The thing is it was working fine till last friday our server re-started...

Thanks for reply

Actually i want first reopen date. For example even if i have four rows with reopen status i want new date as first reopen status date.

Other difficult...

Thank you very much for reply...

I can't use simple select statment because i need min start_date where status is open untill status change to reopen.

for example with id 1 i...