Sometimes our DTS package are returning an error, Timeout expired - Error
code: 80004005, even though we have set the Timeout options=0 and all other
options we could think of.

Are there any options you could think of, that we might have missed or any
other solution we might try?
It is really important that this DTS package keep running all night, because
we have a very large amount of data.

Regards,

Ejnar Jakobsgaard
TDC - Denmark



-------------------
DTSStep_DTSExecuteSQLTask_10

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Timeout expired
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0

Fail package on error=0
Command Time-out=0


INSERT INTO [WORK].[dbo].[RgnNet_Regnskab]
([Virksomhedsnr],
[Ansvar],
[KonverteretAnsvar],
[Art],
[KonverteretArt],
[PHArt],
[BQCArt],
[Artskode],
[Arbejdsart],
[KonverteretArbejdsart],
[Aktivitet],
[KonverteretAktivitet],
[Produkt/Tjeneste],
[KonverteretProdukt/Tjeneste],
[PHProdukt/Tjeneste],
[BQCProdukt/Tjeneste],
[Afregningspart],
[KonverteretAfregningspart],
[Geografikode],
[KonverteretGeografikode],
[Projektnummer],
[Tekst],
[AttesteretBrugerID],
[Valgfri],
[Momskode],
[Oprindelse],
[Tilstand],
[OprettelseBrugerID],
[OprettelseTimestamp],
[Postart],
[Version],
[Subversion],
[Current],
[Foedesystem],
[ForecastKr],
[ForecastPcs],
[Dato],
[Indlaest],
[Transaktionstype],
[Bilagsnummer]
)
select
[Virksomhedsnummer],
[Ansvar],
[KonverteretAnsvar],
[Art],
[KonverteretArt],
[PHArt],
[BQCArt],
[Artskode],
[Arbejdsart],
[KonverteretArbejdsart],
[Aktivitet],
[KonverteretAktivitet],
[Produkt/Tjeneste],
[KonverteretProdukt/Tjeneste],
[PHProdukt/Tjeneste],
[BQCProdukt/Tjeneste],
[Afregningspart],
[KonverteretAfregningspart],
[Geografikode],
[Geografikode],
[Projektnummer],
[Tekst],
[AttesteretBrugerID],
[Valgfri],
[Momskode],
[Oprindelse],
[Tilstand],
[OprettelseBrugerID],
[OprettelseTimestamp],
[Postart],
[Version],
[Subversion],
[Current],
[Foedesystem],
[ForecastKr],
[ForecastPcs],
[Dato],
getdate(),
'Forecast',
'Forecast'
from dbo.RgnTDK_Forecast
WHERE (KonverteretAnsvar IN
(SELECT ansvar
FROM dbo.tdc_organisationsansvar_styr
WHERE Division = 'N'))

Can you tell us what database you're using?

"jakobsgaard" wrote:

yes :-)

Configuration
---------------
Windows 2003 server
SQL server 2000 SP3

--------------------------
"Miguel Salles" wrote:

An EXISTS may be more efficient than your IN statement here.

Also if there is a timeout ensure network access is good.
Make sure the Win2k3 server is not blocking you.
Make sure the resources are not being totalled by someone else

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"jakobsgaard" <jakobsgaard (AT) discussions (DOT) microsoft.com> wrote

I am having this same problem. Have you found a solution yet? I am running
MSSQL 2000 on Windows 2000

"jakobsgaard" wrote: