Re: Very Critical, Please help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

One more thing

My Main dts package calls many other simple dts packages.
When my main dts package calls other dts packages getting timeout
immediately.

Is there any settings at package level to increase the timeout.


"DKRReddy" <dkrreddy@xxxxxxxxxxx> wrote in message
news:u70QfalsFHA.436@xxxxxxxxxxxxxxxxxxxxxxx
> Info :
>
> No new logins, all jobs are using "sa" login.
> Recreated the jobs and dts packages on the new server.
>
> Only user databases were dettached and attached and ran the checkdb
against
> all dbs found no errors.
>
>
> "DKRReddy" <dkrreddy@xxxxxxxxxxx> wrote in message
> news:%23df9jAlsFHA.1168@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)
  • 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)
  • Re: Very Very Urgent, Please Help
    ... does your packages are stored in the MSDB database? ... Have you changed your main package to use the right SQL Server instance? ... When my main dts package calls other dts packages getting timeout immediately. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Very Critical, Please help
    ... Check with your Server team to make sure that nothing emanating from the SQL Server is being blocked from leaving the box. ... My Main dts package calls many other simple dts packages. ... >> Step Error Help Context ID:0 ... >> General network error. ...
    (microsoft.public.sqlserver.dts)
  • DTSRun Frequent Crashes
    ... It runs 16 DTS packages scheduled to run once per minute via SQL Server ... server but each DTS package only accesses a single database. ...
    (microsoft.public.sqlserver.dts)