Post reply

dts timeout question

  • April 21, 2006 at 8:09 pm

    #90889

     

    Hi

    I have posted this question in DTS package section too. But sdidn't get any response. SO thought of posting it in this section. I really need the answer to this.

    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

  • April 23, 2006 at 8:45 pm

    #633690

    I don't do much with DTS packages but I believe it will give you some indication as to which job step failed.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • April 24, 2006 at 10:36 am

    #633857

    Kavita,

    I replied to you post in the DTS forum.

    Greg

    Greg

  • April 24, 2006 at 10:40 am

    #633859

    thanks much

     

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

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