Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS Web Service Time-out

Author  Topic 

daveofgv
Starting Member

6 Posts

Posted - 2010-08-14 : 12:11:49
I have a quick question, hopefully someone can answer. At work, we uses SQL Server 2005 SP3. I have a SSIS Package that uses a Web Service. We have a time-out issue of 100 seconds when downloading. I do know that this bug was suppose to be fixed with SP3 from microsoft, however, we are still getting it. I set the option to 300 seconds (max) and still get a time-out at 100.

Does anyone know why I am still getting a 100 second time-out from a Web Service with SSIS?

Thanks in advanced....

daveofgv

kongaung
Starting Member

8 Posts

Posted - 2010-08-17 : 23:17:42
you should like to consider about the non- volatile and volatile memory. if you has time out error left you should clan buffer, cache and you should shutdown your DB server for a while.

your case can be solve..
zar ni mg
Go to Top of Page
   

- Advertisement -