Why does DTS package failed to execute?

• Diema

  SSC Enthusiast

  Points: 161

  More actions

  July 21, 2004 at 5:32 am

  #180970

  I have a  DTS package,scheduled to execute every minute.It was working properly at the beginning,but next day it statred to fail from time to time.In an hour it succeeds 13-15 times.In other times it fails. I have no explanation.What can cause this failure?

  sp_datetime_last4 converts  date & time string columns from another table into one datetime column in Last4

  Package contains something like this:

  BEGIN

  exec sp_datetime_last4

  UPDATE    Last4

  SET  NEL_TGB =(SELECT  bl4_GAK46   FROM bl4_GAK_lastmin), 

         NEL_TGA =(SELECT  bl4_GAK45  FROM  bl4_GAK_lastmin)

                        .....and other columns

  INSERT LastMin4_New  SELECT [DateTime],NEL_TGA, NEL_TGB  from last4

  /* this insert updated record into another table*/

  END

  Could someone help me!

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  July 21, 2004 at 10:52 am

  #515505

  Are you not logging the dts itself? That would provide more information into the errors that you are getting.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net