I am using SQL Server 7.0 on a NT box. I have a DTS package which
returns a "Timeout Expired" error when using a VB script active task
object to call a stored procedure (through an OLEDB connection). I
have trimmed down the procedure and indexed the tables, such that in
Query Analyser the procedure can take as little as 18 seconds and still
get timed out when called using the DTS package. Is there a timeout
property, option or variable I can set such that the procedure can
be run comfortably. The OLEDB connection links the DTS package
to a database on the same server, so the connection shouldn't be
a problem, should it?

Thanks, Joshua