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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Activex Issue

Author  Topic 

nbkr3bi
Starting Member

15 Posts

Posted - 2007-12-19 : 05:02:17
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?
   

- Advertisement -