DTS Package Timeout error

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.Hi
I have never seen this and don't know where you can set the timeout you may
want to post to microsoft.public.sqlserver.dts.
You don't say which version of SQL Server you are using, what version of
MDAC is installed and if the sub-package is a file or not.
Does the package work if run manually?
Does SQL profiler show anything?
John
"DKRReddy" wrote:

> 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 Provid
er
> for SQL Server
> Help file:
> Help context: 0.
> Process Exit Code 1. The step failed.
>
> Please advise.
>
>