I have an orchestration that makes a call to a web service. The web service starts the SQL Server DTExec utility, which runs a SQL Server Integration Services (SSIS) package.
The orchestration is supposed to wait for a response from the web service. If the web service does not send a response within 5 minutes, I receive this error message:
[i:d6bda01fdc]
Event Type: Warning
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5743
Date: 05/08/2006
Time: 11:07:08
User: N/A
Computer: BIZTALKDEV2
Description:
The adapter failed to transmit message going to send port \”DINEWebService\” with URL \”http://ykclnsd/DINEWebService/Service.asmx\”. It will be retransmitted after the retry interval specified for this Send Port. Details:\”WebException: The operation has timed out \”.[/i:d6bda01fdc]
The SSIS package will run several data loads that will take hours to complete. I must find a way to increase the timeout for this Send Port, but I don’t see any SendPort properties that allow me to configure the timeout. The only property that even comes close is:
Transport Advanced Options -> Transport Options -> Retry Interval
Is the timeout a property that can be set in the Administration console, or do we need to do custom coding? Is there something else I should be looking at in order to resolve this problem?
Thanks in advance for your assistance.