We have a sql server 2000 job that invokes a DTS. A log file has been specified for the job. Now we are using ActiveX script(using objTextFile.WriteLine) within the DTS to write to the same log file depending on certain conditions that happen within the DTS. Now, the issue is that if I use the same log file in DTS as is being used in the job, it is not able to write to the file and just prints all boxes (?). If I use a different log file, it is able to write. But I need to be able to write to the same log file. Any suggestions??
I think, in DTS you have multiple jobs and you are opening that particular file once and after completio,n you are closing it! If so, try to open and close it for every individual job. I think, that may solve your problem. Let me know your exp also after implementing it.