Sql server DTS Script probs

  • Thread starter Thread starter Anjali
  • Start date Start date
A

Anjali

I have scheduled DTS Scripts to run automatically for
every 2 hrs.
Sometime one Process is blocked by another, in that case
then Table is locked related to that DTS Script.
so It can not run the next scheduled script.

Could you please help me why processes are blocked and How
I get rid of that?

thanks in advance
Anjali
 
Hello,

Anjali said:
I have scheduled DTS Scripts to run automatically for
every 2 hrs.
Sometime one Process is blocked by another, in that case
then Table is locked related to that DTS Script.
so It can not run the next scheduled script.

Could you please help me why processes are blocked
and How I get rid of that?
Click to expand...

Are you talking about VB.NET?
 
Back
Top