MS SQL Server DTS - DTS Package Timeout error

Author

DTS Package Timeout error

DKRReddy

2005-10-27, 7:57 am

I have two simple dts pacakges , DTS_Main and DTS_Sub.
DTS_Sub being called from DTS_Main.
When DTS_Main calls DTS_Sub getting the following timeout error while
calling the package not while executing.
Is there any settings I can set to increase the time out setting when
calling sub package.Both dts packages
exists in Same SQL server (SQL 2000 SP4 + Windows 2003), the server is 8
processor with 12 GB Ram.

Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Timeout expired Error source: Microsoft OLE DB Provider
for SQL Server
Help file:
Help context: 0.
Process Exit Code 1. The step failed.

Please advise.

Thomas Bradshaw via SQLMonster.com

2005-10-27, 7:57 am

DKRReddy,

This isn't a package timeout error, because the error you specify originates
from the 'Microsoft OLE DB Provider for SQL Server', one of the connections
you have - most likely in DTS_Main.

Allan Mitchell from www.sqldts.com writes this:

====================
=======
On the properties of the SQL Server connection there is

Connection Timeout
General Timeout
====================
=======

Another idea is to optimize any queries so that the work completes faster,
thereby avoiding the need to play with connection timeouts. Just a thought.
Anyone else have other thoughts?

Let us know how you make out.

Thomas Bradshaw
MyWebGrocer.com
Data Integration Services

--
Message posted via http://www.webservertalk.com

Sponsored Links