Re: Very Very Urgent, Please Help

can you create a new empty package and create a new connection to the database?

have you validated the connections in your packages?



"DKRReddy" <dkrreddy@xxxxxxxxxxx> wrote in message news:OeJz4AlsFHA.3604@xxxxxxxxxxxxxxxxxxxxxxx 
Recently we have migrated the datawarehouse server  to windows 2003 server
from windows 2000 server.
Since then all dts packages are getting timedout with the following error.

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


The new server is very high end server which has 8 processors and 12GB RAM,
and All dts packages are having simple deletes and data transfer tasks.

Daily updatestats was running  during off hours and proper indices are
there.
Ran the checkdb on all dbs, found no errors.

I never seen these kind of erros on windows2000 and sql 2000 ee sp3.

Is there any reason that sql2000 EE SP3 is not fully supported by Windows
2003 server.

I have verified the query timeout settings on source and destination server
which is 0 (unlimited)

Please let me know if settings need to be checked.



(Migration : dettahed the databases from windows 2000 server and sql200 EE
sp3 and attached to the windows2003 server and Sql 200 EE sp3)


If any queries that were run from query analyzer are failing with the
following error afetr few minutes :

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken




.

Relevant Pages

  • RE: Recover SQL files & DST packages from server backup
    ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... >> Server Settings''. ... >> In order to backup and restore the DTS Packages, ...
    (microsoft.public.windows.server.sbs)
  • Connecting using Microsoft OLE DB Provider for DB2 (AS/400 TCP/IP)
    ... I am trying to create DTS Packages that work bidirectionally between a DB2 ... setting Network to TCP/IP and putting the proper IP ... In all cases I get the same result when I press the Test Connection button. ... should be a server specific error, but I cannot find that in the IBM ...
    (microsoft.public.data.oledb)
  • Client does not reconnect to SQL Server after Network interruption
    ... Our VB.NET program onnects to SQL Server SP4 via OLEDB. ... connection and then we have a network interruption of min 10secs during ... get a General Network Error when we try to execute the next query. ... The only way to reconnect to the server is to restart the VB program. ...
    (microsoft.public.sqlserver)
  • Re: Client does not reconnect to SQL Server after Network interruption
    ... > Our VB.NET program onnects to SQL Server SP4 via OLEDB. ... > connection and then we have a network interruption of min 10secs during ... > get a General Network Error when we try to execute the next query. ... > The only way to reconnect to the server is to restart the VB program. ...
    (microsoft.public.sqlserver)
  • it all started on 5/27....
    ... individual DTS packages on SQL Server 2000 SP 4 that import and convert ... The SQL lives on a separate server than Pervasive. ... the same machine as SQL Server 2K SP 4. ... Now, if I execute the DTS packages individually on the server, all ...
    (microsoft.public.sqlserver.dts)