DTS weird behaviour????????

  •  

    Hello guys..i m in weird here..

    I already posted it in DTS forum but didnt get any solutions..so i posted it again here in trusted group....

    We have some DTS packages here scheduled to run..Sometimes we got error that job failed. When i checked it in event viewer i got message like.....

    Step 'DTSStep_DTSExecuteSQLTask_16' succeeded

    Step Execution Started: 12/20/2005 5:43:35 AM

    Step Execution Completed: 12/20/2005 5:43:42 AM

    Total Step Execution Time: 6.672 seconds

    Progress count in Step: 0

    Step 'DTSStep_DTSExecuteSQLTask_17' failed

    Step Error Source: Microsoft OLE DB Provider for SQL Server

    Step Error Description:Timeout expired

    Step Error code: 80040E31

    Step Error Help File:

    Step Error Help Context ID:0

    Step Execution Started: 12/20/2005 5:48:31 AM

    Step Execution Completed: 12/20/2005 8:35:13 AM

    Total Step Execution Time: 10001.61 seconds

    Progress count in Step: 0

    Step 'DTSStep_DTSExecuteSQLTask_18' succeeded

    Step Execution Started: 12/20/2005 5:30:02 AM

    Step Execution Completed: 12/20/2005 5:30:16 AM

    Total Step Execution Time: 14.14 seconds

    Progress count in Step: 0

    Step 'DTSStep_DTSExecuteSQLTask_19' succeeded

    Step Execution Started: 12/20/2005 5:43:53 AM

    Step Execution Completed: 12/20/2005 5:44:48 AM

    Total Step Execution Time: 55.656 seconds

    Progress count in Step: 0

    What may be reason cause this failure and another thing is that see failure occure at 'DTSStep_DTSExecuteSQLTask_17' and see the time for started and completed..after that step no. 18 and 19 executed and see their time...how that was possible before completion of this step 17 how step 18 nad 19 completed????..I chked in log also same thing i observed that 'DTSStep_DTSExecuteSQLTask_1,'DTSStep_DTSExecuteSQLTask_2,

    'DTSStep_DTSExecuteSQLTask_6'  (actually it shoud be 'DTSStep_DTSExecuteSQLTask_3..????) wheather these number 1,2,6,..like that17,18,19 is logically sequenced with actual runniing step??? please guide me what u observed in above confusing senario......pls help me out ..its urgent...



    Regards,

    Papillon

  • What is task 17 doing?  I've seen timeout expired errors due to poor or lack of indexing.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • The task 17 is definitely causing an issue with your package.

  • Papillon,

    I've replied to your thread in the DTS forum.

    Greg

    Greg

  • Try to Shncrhonized the threads...right click on DTS designer while opening the package and check

    NUmber of threads->1

    Execute package on main thread->ON

    and then run with appropriate dependencies of COMPLETION of previous steps..

     

    Hope this Helps

     

    Regards

    -Nirmal.

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

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