Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Truncation Error from XML Source in a dataflow task

Answered Truncation Error from XML Source in a dataflow task

  • Tuesday, October 10, 2006 9:09 PM
     
     
    Sign In to Vote
    0

    I am trying to use an XML Source on xml data from an XML webservice, I am putting the document into a variable the trying to import the data from there with the XML Source, but I am getting an error telling me that truncation occured

    The Error is "[XML Source [1]] Error: The "component "XML Source" (1)" failed because truncation occurred, and the truncation row disposition on "output column "linking" (1579)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component."

    The linking column mensioned in the error is sometime quite a long string but there is nowhere in the XML Source editor to change the size.

    HELP! 

     

All Replies

  • Tuesday, October 10, 2006 10:12 PM
     
     Answered
    Sign In to Vote
    1

    Hi there,

    You can right click on  XMLSrc, choose "Show advanced editor", there from "Input and Output Properties" tab, find the related output, then the output column(s), change the string column length from the default 255 to a more appropriate value.

    HTH

    wenyang

     
  • Wednesday, September 12, 2012 8:37 AM
     
     Proposed
    Sign In to Vote
    1

    Hi Wenyang,

    Thanx its working Now!!!!!

    • Proposed As Answer by Mak215 Thursday, September 13, 2012 4:01 AM
    •