DTS VBScript Stored Proc Timeout Issue

[u104741]

high i hope someone can help me....

within a DTS package i use some vb script to kick off a stored procedure. The problem is that sometimes the stored proc has to run for maybe 5 minutes.

becuase of this i often get a timeout error on this task when running the DTS pacakge. is there a way to specifiy the timeout when the step runs.. it tells me the sp timed out while executing...

when i run the stored proc form query analyser it runs just fine???

There must be an easy answer...

some along the lines of;

exec sp_name paramterA, paramterB, timeoutvalue ??

 

[JohnDTampaBay]

CommandTimeout Property
Indicates how long to wait while executing a command before terminating the attempt and generating an error.

Settings and Return Values
Sets or returns a Long value that indicates, in seconds, how long to wait for a command to execute. Default is 30.

Remarks
Use the CommandTimeout property on a Connection object or Command object to allow the cancellation of an Execute method call, due to delays from network traffic or heavy server use.


--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[u104741]

thank you. all sorted.