You can configure the status tracing level of the Data Services transformation to write status messages to output fields. The Mapping Designer creates UDT_Status_Code and the UDT_Status_Message output fields in the Data Services transformation.
When you choose to write the description only, the transformation returns a status code and one of the following status messages:
Status code
Status message
1
Success
2
Warning
3
Failure
4
Error
5
Fatal Error
When you choose to write the full status, the transformation returns a status code and a detailed XML status message.