Help on DTS-Openquery timeout on linked server

I have:
- One linked server
- One DTS with an OpenQuery on linked server
I set the Connection Timeout and General Timeout on the DTS Connection to 0
I set the Command Timeout on DTS Step to 0
I set the Connection Timeout and Query Timeout on the Linked server to 0
Always I receive a provider timeout after 10 minutes.
This is the query:
INSERT INTO openquery(history,'select * from
HistoryContact.dbo.AnomalContact')
SELECT Contact.*
FROM Contact INNER JOIN openquery(storico,'select * from
HistoryContact.dbo.HistoryContact) as CS
ON (Contact.ID = CS.ID) WHERE Contact.STATE<>'0'
Anyone know why?
Thank you very much.
RobertoRoberto
Do you have ping to remote/linked servers?
"Roberto Rasto" <rastoroberto@.hotmail.it> wrote in message
news:ds4pga$bpj$1@.nnrp.ngi.it...
>I have:
> - One linked server
> - One DTS with an OpenQuery on linked server
> I set the Connection Timeout and General Timeout on the DTS Connection to
> 0
> I set the Command Timeout on DTS Step to 0
> I set the Connection Timeout and Query Timeout on the Linked server to 0
> Always I receive a provider timeout after 10 minutes.
> This is the query:
> INSERT INTO openquery(history,'select * from
> HistoryContact.dbo.AnomalContact')
> SELECT Contact.*
> FROM Contact INNER JOIN openquery(storico,'select * from
> HistoryContact.dbo.HistoryContact) as CS
> ON (Contact.ID = CS.ID) WHERE Contact.STATE<>'0'
> Anyone know why?
> Thank you very much.
> Roberto
>|||Yes, a small query is executed.
The query below need approximately 30 minutes normally, so I need an
infinity timeout.
Ho can I force this timeout?
Thanks.
Roberto
"Uri Dimant" <urid@.iscar.co.il> ha scritto nel messaggio
news:%23KLCltlKGHA.344@.TK2MSFTNGP11.phx.gbl...
> Roberto
> Do you have ping to remote/linked servers?
>
> "Roberto Rasto" <rastoroberto@.hotmail.it> wrote in message
> news:ds4pga$bpj$1@.nnrp.ngi.it...
>sql