Catching XML Source Error in SSIS

I am using XML source as my data flow source. If it encounters an error, SSIS will catch the pipeline error, but not the XML Source error, which is more descriptive.

We use the OnError event handler on the data stream where the XML source resides to get a system variable error message that gives a "pipeline" error. How can we get the system to catch the XML source error?

Here are examples of two errors:

[XML Source [1]] Error: XML Source component (1) could not read XML data. Could not find part of path '\ thefilepath \ thefile.xml'.

[SSIS.Pipeline] Error: The XML Source component (1) did not go through the preparation stage and returned error code 0xC02090E7.

+3


source to share





All Articles