dts time out

  • I am new to DTS package. I am thinking to build 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

  • Can anybody answer my question please? I really need to know this.

  • If you turn on logging in the package, it will log each step and tell you which one failed.  In the event of a timeout, you'll see which step was being executed at the time. 

    Turn on logging by selecting Package Properties, select the Logging tab, and either check the 'Log package execution to SQL server' box or designate a log file under Error handling.

    Greg

    Greg

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply