Hello all, Iam trying to load xml files,the xmlsource is giving errors when new xml file is arrived with same structure. The error is [XML Source [1482]] Error: The value was too large to fit in the output column Many Thanks siddu

Check the columns to which you are assigning values and investigate the xml for values which would overflow the given data types. For instance, the default string size is probably 255 and you might recieve a string that is 500 characters, etc...Please mark answered posts. Thanks for your time.