dbTalk Databases Forums  

DTS logging to textfile

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS logging to textfile in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default DTS logging to textfile - 05-25-2006 , 03:44 PM






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 log
information. Now, I cannot use fileSystemObject directly in DTS because
I 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. For
this reason I am using FSOWrapper as mentioned in
"http://support.microsoft.com/kb/325791" but there are some serious
memory leaks when I use this wrapper and I need to find an alternate
solution 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 an
efficient component. ASP.NET I am using Log4Net component which is very
efficient but have to clue for DTS.

Set obj = CreateObject("FSOWrapper.CMyFileSystemObject")
obj.OpenTextFile "LogFile.txt" , 8, True
obj.WriteLine LogText

Thank you in advance
Chandra


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.