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 rajIf 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
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>