truncated errordescription in sysdtssteplog

[Hablaras]

Hi,

A dts package can log errors per step to the sysdtssteplog table. An error description can be found in the errordescription field.

HOWEVER, this message is maximum 256 characters long, while the datatype is nvarchar(2000). Some descriptions are truncated, while I need the entire message.

Any ideas how to get the full description (more then 256 characters) in that field? Importing it from the error textfile has no preference.

Thanks in advance,

gr.,

Hablaras

 

[JayKusch]

Not sure how to change that field length and since it is a system table you should AVOID touching it. I would suggect that you turn on logging for your package. You can do this my opening you DTS package and from the menu bar choose ...

Package..Properties..Logging and under error log, set a text file up to capture your packages execution.

Thanks

J. Kusch

 

[Hablaras]

That is what I meant with "error textfile". Not the most accurate terminology from my side.

Thanks anyway, guess it is the only solution.