Timeout Error during the Transfer…… | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Timeout Error during the Transfer……

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
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.
No.it did not work at all. In first run it self it started giving problems. raj
check whether the both servers have SP4 —————————————-
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. —————————————-
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
This posting is provided AS IS with no rights for the sake of knowledge sharing.