I've created a SSIS package, which reads my XML file using XML Source, using SCD(Slowly Changing Dimension) to identify whether to do an Insert/Update and everything's fine so far. But there are chances that my xml file will have new tags added apart from
what are already there. So In that case, i'm not able to figure out whether to alter the table to add new column or something like that.
Need your suggestion.
Thanks in advance
View Complete Post