Re: dts Logging

Any thoughts on why the following isn't making it to the log file.. (log
file is set to 16mb with overwrite as needed)

errorFlag is True and package is reporting a failure to the GUI.

If (errorFlag) Then
DTSGlobalVariables("ErrorMessage").Value = errMsg
DTSPackageLog.WriteStringToLog errMsg
Main = DTSTaskExecResult_Failure
Else
Main = DTSTaskExecResult_Success
End If

Bill


"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:uj8KV6yhFHA.2644@xxxxxxxxxxxxxxxxxxxxxxx
> You can write to the log but ONLY from the AX Script task using
> WriteStringToLog() method. Everything else though is set in stone (at
> least for the current release)
>
> --
>
>
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
>
> "Bill Swartz" <wsaharem@xxxxxxxxx> wrote in message
> news:uB9A91yhFHA.4048@xxxxxxxxxxxxxxxxxxxxxxx
>> 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
>>
>
>


.

Relevant Pages

  • Re: 1352 NUL bytes at the end of a page?
    ... Andrew Morton wrote: ... >> We've got a user who's reporting BK problems which we've traced down to ... >> correct file data picks up again after the hole. ... at the same time as the bk failure, ...
    (Linux-Kernel)
  • Re: If condition
    ... will always be successfull, I change the precedence constraint value of the ... >> In a DTS I want to transfer data only if some conditions are met. ... >> I use an ActiveX task to check the conditions. ... >> Failure and the step is shown as failed. ...
    (microsoft.public.sqlserver.dts)
  • Re: [Lit.] Buffer overruns
    ... percent of failures/exploits for the specific environment that are ... detailed study of the reported types of failures and the failure ... occurances of a specific failure cause to a single failure reporting ... and/or using pointers after the related operations had all be ...
    (sci.crypt)
  • Re: failing step fails job
    ... Then the only time you would use the 'on failure' workflow option in dts ... > The only thing to do is to prevent any steps from failing during ... > Skip the execution of an individual Task ...
    (microsoft.public.sqlserver.dts)
  • aio_sgi_init: dlopen failed, cannot map soname libdba.so
    ... I have an application using ffio that is reporting a failure in aio_sgi_init: ... aio_sgi_init: dlopen failed: Fatal Error: Cannot Successfully map soname 'libdba.so' under any of the filenames. ...
    (comp.sys.sgi.admin)