Posted by Al-Pacino on 10/01/73 11:42

Hello All,

I am am having a strange problem. I am trying to execute a DTS package
from VB .NET (.aspx) page. The DTS package takes 21 minutes to execute.

When the aspx page sends a command to MS SQL server to execute this DTS

package it starts executing. After 8 minutes the .aspx page shows error

"Cannot Find Server" and errors out with a white screen. The
inetresting thing is the DTS package is still being executed in backend

and completes execution successfully.


I have no clue why this is happening because there are other DTS
packages that I am executing through the same .aspx page that takes
about 3 minutes to complete execution and are working absolutely fine.


By the way I have a stored procedure wrapper over every DTS package. So

when i have to execute a DTS package I execute a stored which inturn
executes a DTS package.


Thanks for reading my query. If you have any suggestions please let me
know.


Thank you in advance.

• Next in forum: Re: Getting list of recently added IDENTITY items
• Prev in forum: Re: 2005 Database Mirroring & Witness
• Thread view: Browser Time Out: when executing a DTS package

[Reply to this message]