Hi,
I am logging the execution of a package to a log file
using the logging capability on the package properties.

However, I don't like the fact that each new run logs to
the same log file just seperated by a line of asterixs.
What I want to do is, on each seperate package execution,
output to a file called "filenameYYYYMMDDHHMI.log" or
something similar. You get the idea.

So, how do I dynamically change the name of that log file.
Obviously I need an ActiveX Script to do this but none of
the documentation that I have tells you the name of the
property which holds the name of this log file. Can anyone
help?

TIA.

Regards
Jamie

sqldts.com has example code for overwriting the error log on each executing
rather than appending, you could modify this code to rename.
http://www.sqldts.com/?240

--
HTH
Ryan Waight, MCDBA, MCSE

"Jamie Thomson" <jamie.thomson (AT) int21 (DOT) com> wrote

Thanks Ryan,
I was looking at that article before I posted and decided then that if
there wasn't a better way then I would do as you suggest. Its not
exactly what I want but it may have to do.

Can someone confirm whether or not it is possible to dynamically change
the name of the log file?

Thanks
Jamie




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Yes and you would do it exactly as stated

You use an Active Script task and set the LogFileName to whatever you want
it to be. You can assign to it the value of a global variable which if
using SQL Server 2000 you can set through DTSRUN and the /A switch.

You can set it dynamically if you want it based on date values by following
this article.

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Jamie Thomson" <frinck109 (AT) yahoo (DOT) co.uk> wrote

Thanks all, thats great.
I missed the reference to <pkg>.LogFileName on sqldts.com

Regards
Jamie



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!