dbTalk Databases Forums  

error message when processing xml file on SQL 2005

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss error message when processing xml file on SQL 2005 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Panos Stavroulis.
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.