Hi,

I have 7 DTS scheduled DTS packages which get data from SQL Server
2000 and write to 7 .csv files. After the scheduled jobs run I check
those 7 text files I found some of them (but not always the same file)
are empty. If I run these DTS packages or jobs manually, I do not get
empty files.

I realised this may be a permission issue as some of the DTS
packages/jobs were written by another employee who has left the
company, what I couldn't understand is, why sometimes I CAN get the
job run properly and sometimes I can't?

Thanks for any response.

Kind Regards,

Bob