Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brettfreer
Starting Member
1 Post |
 Posted - 2006-05-14 : 19:06:35
|
| 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 Freerbrett@rhapsody.com.au |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-15 : 03:52:21
|
| Without a bit of info about how the job works it's difficult to give an opinion.I doubt if it will be a problem with DTS itself.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS job appears to 'cache' input text files