Running DTS thru scheduled sql job

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  December 14, 2007 at 1:35 pm

  #70553

  I have a DTS package which has about 12 dts inside it and it runs thru a scheduled sql job. This package loads data from flat files to sql tables.

  This package started last night 11PM and I checked the job and it says still executing. I checked the application log and system log inside event viewer but I do'nt see anything related to that. How can I trouble shoot this problem? Any ideas. Thanks!

• Eshwaran

  SSC Veteran

  Points: 229

  More actions

  December 18, 2007 at 7:05 am

  #760995

  Hi,

  Add the log file to the DTS package. I will help you in knowing how dts is running where you are getting error.