Hello,

We are using AS on SQL-Server 2000, SP3, W2K...
We want to generate a log file that contains ALL steps
and information of the DTS job execution (the same
information that are present in the DTS "Log Detail" of
the DTS Package Log), whatever the result of the
execution is (success or fail...).

Then in the "DTS Package properties", "Logging" tab,
field "Error file" we defined a folder and a file name.
But this file is created/populated only in case of
failure of the job execution (normal ?).

Do you know how we should proceeed to get in a file all
the trace of the job execution, knowing that:
- we don't have admin rights on the server machine
- we are not admin of SQL-Server
- ...and as a consequence, we don't have access to Log
Details of the DTS package....

Many thanks for your help

Abdou

Abdou,

On the "Logging" tab, check "Log package execution to SQL Server". In
Enterprise Manager,
open the Data Transformation Services/Local Packages folder, rightclick the
package and choose "Package Logs".

This info is stored in the sysdts% tables in the MSDB database. To generate
a file, create and schedule a DTS package to dump this info to a textfile.
Or even nicer, use the Web Assistand Wizard to generate a nicely formatted
html report based on a query against the sysdts% tables.

Jon Jahren


"Abdou" <faye.abdourahmane (AT) eu (DOT) altria.com> wrote

Hi Jon,

I thank you for your help.

In fact what we would like is to get this file generated
WHENEVER someone executes a DTS package. Not at a
scheduled time...

Personnaly, as the administrator, I have access to sys
tables and the Package Logs. But this is not the case for
our developers, since they don't have admin rights (and
will not have it !!).

So my question is: How can we generate this LOG WHENEVER
someone executes a DTS package, whatever the status of
the execution is (failed or not), with the trace of
everything done ?

Many thanks

Abdou