dbTalk Databases Forums  

Browser Time out: When executing DTS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Browser Time out: When executing DTS package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Al-Pacino
 
Posts: n/a

Default Browser Time out: When executing DTS package - 03-15-2006 , 09:20 AM






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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.