Unusal Results from DTS package

• lostdrifter0001

  SSC Enthusiast

  Points: 164

  More actions

  January 15, 2010 at 6:50 am

  #386110

  I'm running SQL Server 2000 and I have a single DTS package that seems to be cause me a bit of trouble. The package itself goes out and get data from a group of Visual Fox Pro DBF. and one at a time imports the contents of the DBFs into SQL server. I have this running on a schedule, but I have noticed that every now and then one table in particular will not be imported but the job does not fail either. The data is important and I need to import it every day. Any thoughts?

• RP_DBA

  SSCertifiable

  Points: 5116

  More actions

  January 15, 2010 at 8:22 am

  #1104241

  In the DTS package, is the precedence between steps set to success or completion? This would affect how the job status is reporting.

  _____________________________________________________________________
  - Nate

  @nate_hughes

• lostdrifter0001

  SSC Enthusiast

  Points: 164

  More actions

  January 21, 2010 at 8:57 am

  #1106766

  There is none, its just a simple task to get data from one source to the other.