Re: Newbie - logging to exception files from data pump task

#1

1. Look for the ExceptionFileName property of the datapump task (You could
have the Dynamic properties task populate a Global Variable. You would then
loop through the package tasks and set the property.
2. Yes you can use 1 Exception file bubt note that tasks writing to the
file executing in parallel may fail due to "File opened by Another process"
errors
3. Not really no. There is the DTSPackageLog object but that is available
in the AX Script task only

--

----------------------------
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" <jamie.thomson (AT) int21 (DOT) com> wrote

Quote:

Hi there,
Hopefully what I'm about to ask isn't too hard. its
regarding exception file logging in the data pump task.

I want to make sure that all of the exception logging from
my DTS app goes to the same file. In addition I want the
name of the file to be dynamic (e.g. name of it is stored
in an .ini file)

I know how to get values from a .ini file (Dynamic
Properties task) but how do I dynamically stick that value
into the path for my exception file in all of data pump
tasks?

Also, will each data pump task overwrite the exception
file each time or will it just append to it? (Obviously I
need it to append).

Lastly, is there a way to configure exactly what goes into
the exception file? So I can put my own error messages in
there - things like that.

Thats all. Thank you very much in advance.

Regards
Jamie

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Newbie - logging to exception files from data pump task

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

Re: Newbie - logging to exception files from data pump task - 07-17-2003 , 02:53 PM