Storing the ErrorDescription on DFT -> Flat file error output

I have a Flat File Source that redirects bad rows to a DB Destination. I can Audit and get the ErrorCode (as well as an ErrorColumn, whatever that is?) but I need to save the error description as well. Is there a way to do this? How?

Also, is there a way to email the error description / rows in the data flow
task?

Thanks,
Jason

[342 byte] By [scoobyjw] at [2007-12-16]

«« Asynchronous web service
»» Visual basic deplyment bootsrapper

# 1

No idea about the error description... Never thought about that...

You can find out about the error column when you open the advanced editor of the transform you get the error from. You find column ids for the output fields there.

ThomasPagel at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

# 2

The standard error output adds 2 columns for the error code, and the id of the column in which the error occurred.

The simplest way to get the error description (programmatically) in the data flow is by using the GetErrorDescription method of the IDtsComponentMetadata90 interface in the Pipeline.Wrapper namespace.

You could run your error output through a Script component (which provides convenient access to the ComponentMetadata) and use GetErrorDescription to add an additional string column containing the description to the error information.

-Doug

DouglasL at 2007-9-9 >

# 3

Hi Doug,
How come, when you look at the error output in a data viewer, it contains an error description even though the error description is not in the metadata of the data path?

-Jamie

JamieThomson at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech