SQL Server Performance

Active X write to file ISSUE

Discussion in 'SQL Server DTS-Related Questions' started by nbkr3bi, Dec 19, 2007.

  1. nbkr3bi New Member

    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??
  2. anandchatterjee New Member

    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.

Share This Page