SQL Server Performance

Timeout Error during the Transfer......

Discussion in 'SQL Server DTS-Related Questions' started by krajdba, Sep 12, 2006.

  1. krajdba New Member

    Hi Gurus

    I have a Source database and a remote Target db both are SQL Server databases. I have created about 10 DTS Packages in the Source database. When I am running the Packages I am getting "TimeOut Error".

    Help me fix this error.Very Very Urgent Please.

    Thanks



    raj
    krajdba, Sep 12, 2006
    #2

  2. Adriaan New Member

    If it is so urgent, you might take the time to post one or two details, or tell us whether this was working fine before today --- something to go on.
    Adriaan, Sep 12, 2006
    #2

  3. krajdba New Member

    No.it did not work at all. In first run it self it started giving problems.



    raj
    krajdba, Sep 12, 2006
    #2

  4. dineshasanka Moderator

    check whether the both servers have SP4

    ----------------------------------------

    dineshasanka, Sep 12, 2006
    #2

  5. dineshasanka Moderator

    Increase the ODBC query time-out value to improve query performance on large SQL Server 2000 DTS packages stored in a repository.
    Change this registry setting from the default value (10 seconds): HKEY_LOCALMACHINESOFTWAREMicrosoftRepositoryEngineODBCQueryTimeout The ODBC query time-out values are measured in seconds.

    ----------------------------------------

    dineshasanka, Sep 12, 2006
    #2

  6. satya Moderator

    Also make sure both the servers has relevant client alias defined if there are issues on the network with such timeouts.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Sep 13, 2006
    #2

Share This Page