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 2005 Forums
 SSIS and Import/Export (2005)
 Output to Log

Author  Topic 

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2008-01-25 : 17:07:38
I have a simple process that goes through a directory and deletes files older than some number of days. I determine the full filename in a script task by setting a variable and then I use File System Task to do the delete. My goal is to output the file name to a log file. Nothing fancy, just output text (file name) to the default log provider so it can be logged if logging in enabled.

If anyone has any clues on how to do this that'd be great. If you need more information, let me know.

Cheers!

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2008-01-29 : 12:28:46
You could enable the OnVariableValueChanged event and set the RaiseChangedEvent property of your filename variable to True.
Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2008-01-30 : 17:07:57
Thanks,

I'll give that a shot!
Go to Top of Page
   

- Advertisement -