dts Logging

From: "Bill Swartz" <wsaharem@xxxxxxxxx>
Date: Tue, 12 Jul 2005 15:03:07 -0700

Does anyone know how to write to or modify the log output of dts?

Currently the output looks something like this..
DTSRun: Loading...

DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_2
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_2
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3
DTSRun OnStart: DTSStep_ValidateConnections
DTSRun OnError: DTSStep_ValidateConnections, Error = -2147220421 (8004043B)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp

I intentionally failed this, but want to write to the log a provide some
background about what was happening and what the failure was.

Thanks
Bill

.

Follow-Ups:
- Re: dts Logging
  - From: Allan Mitchell

Prev by Date: Identity field problems with DTS
Next by Date: Re: dts Logging
Previous by thread: Identity field problems with DTS
Next by thread: Re: dts Logging
Index(es):
- Date
- Thread

Relevant Pages

Error = -2147220482 (800403FE) Syntax??
... DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: ... DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: ... Transformation Services (DTS) Package He. ...
(microsoft.public.sqlserver.dts)
Re: DTS Failed
... > This jobs worked till yesterday, failed today with error message ... > DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart: ... > No changes made to server or job.. ...
(microsoft.public.sqlserver.programming)
DTS question for Microsoft
... you have a DTS "Execute SQL Task" step, ... that I can see the output from that SQL??? ... DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1 ... DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1 ...
(microsoft.public.sqlserver.server)
Re: Scheduled Job Sometimes Error Sometimes Not
... DTSStep_DTSExecuteSQLTask_10 DTSRun OnFinish: ... DTSStep_DTSExecuteSQLTask_10 DTSRun OnStart: ... Exit Code -1073741819. ... Prev by Date: ...
(comp.databases.ms-sqlserver)
Re: dtsrun.exe hangs before complete
... there fore it would need to be whereever the package is executing. ... www.SQLDTS.com - The site for all your DTS needs. ... > DTSRun OnStart: Create table TABLE1 step ... > DTSRun OnFinish: Create table TABLE1 step ...
(microsoft.public.sqlserver.dts)