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.
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 |
|
|
|
|
|