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.

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.sqlmonster.com