DTS Job appears to ''cache'' input text files

• Brett Freer

  Grasshopper

  Points: 13

  More actions

  May 14, 2006 at 6:15 pm

  #168194

  I have a DTS job, that among other tasks, imports a number of CSV files from a network share. This job has run for years without exception on SQL7 and SQL2K.

  However, about a month ago it appeared to start 'caching' (or reload the previous version of the file) for just one of the input CSV files. There was nothing unusual recorded in the event logs, and the job finishes with no exceptions. The problem only manifests itself when run as a scheduled SQL job - running it manually in the foreground always works.

  The only solution I have found is to re-start the SQL services each night, which seems to solve the problem. Any ideas please?

  Env - SQL2000SP4, Win2003Svr.

  Brett Freer

  brett@rhapsody.com.au

• David Korb

  SSCrazy

  Points: 2505

  More actions

  May 16, 2006 at 10:32 am

  #638211

  You might try executing the BCP utility within a stored procedure. That way you avoid all the bugs in DTS.