error message when processing xml file on SQL 2005 -
04-05-2006
, 06:01 AM
Hi,
I get the following error message....
[DTS.Pipeline] Warning: The output column "prev" (57) on output "prev" (55)
and component "XML Source" (1) is not subsequently used in the Data Flow
task. Removing this unused output column can increase Data Flow task
performance.
This is a composite xml file and prev is one of the outputs. However, I only
want to use the main part of the xml and don't care about the others. So I am
ignoring the 'prev' xml composite as I don't care. I've tried to remove the
output from advanced Edit on xml source but it doesn't let me do it. I've
also tried to say ignore any failures for this output in the error handling
but still no luck.
I know if I add 'prev' as another component to output in a table then it
will work but don't want to do that. Does anyone know how to get rid of this
error message? Thank you.
Panos. |