I'm using the following :
SSIS Version 9.00.4035.00
I have a data flow task within an existing SSIS pkg.
The data flow task loads data from a source xml file to serveral realtional destination tables.
A new data item has been added to the source xml file. Therefore, I created an extra column in the appropriate destination table to accomodate the new data item and recreated the .xsd file.
I mapped the new item in the source xml to the new column in the table.
I keep experiencing the following errors :
The external metadata column "GroupReference" (1812) has no mapping to the XML schema
"component "XML Source" (1)" failed validation and returned validation status "VS_ISBROKEN"
The only way to get rid of the errors is to re-create the data flow task from scratch.
What have I done wrong/how can I eliminate the error??
Thanks in advance.