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 |
|
chandraDutta
Starting Member
1 Post |
 Posted - 2006-06-01 : 09:58:22
|
| Hi All,I have a DTS package which is being called from an ASP.NET program. I have a common text file where both ASP.NET and DTS package loginformation. Now, I cannot use fileSystemObject directly in DTS becauseI need to use the impersonated ID(as the main user might not have access to the text file) which is set in the ASP.NET web.config. Forthis reason I am using FSOWrapper as mentioned in"http://support.microsoft.com/kb/325791 " but there are some seriousmemory leaks when I use this wrapper and I need to find an alternatesolution to write to the text file.Appreciate any help with this and please let me know if you need any more information. Basically need to replace this piece of code with anefficient component. ASP.NET I am using Log4Net component which is veryefficient but have to clue for DTS.Set obj = CreateObject("FSOWrapper.CMyFileSystemObject")obj.OpenTextFile "LogFile.txt" , 8, Trueobj.WriteLine LogTextThank you in advanceChandra |
|
|
|
|
|
DTS logging to textfile