question on DTS package
I am new to DTS package. I am thinking of building a DTS package having 3 stored procedures. Second stored procedure should start the execution after 1st stored procedure is successfully executed and 3rd stored procedure should start the execution after second stored procedure is successfully executed. My stored procedures are really big. So my DTS package might time out. Would my DTS package tell me which stored procedure timed out or would it just give me the error message that DTS is timed out?
Thanks
Kavita
|