I am loading XML file using SQL 2005 SSIS and using XSD file for XML Schema defination.
Now I have a requirement where I should add couple of new columns in XSD as the XML (MAY) have extra columns for few of its tables.
Is it safe to add new columns to XSD and the Map only new columns in Data Flow and all will work? or after I add new columns I need to redesign all mappings as Column order will change. (I think SSIS refere a numeric value for each column, if Yes how can I
add new column with less impact)?
View Complete Post