I have an XML file as a data source and I am willing to extract the data and store it in SQL Server database, and I am using SSIS for that. There is a XML Source data flow component in SSIS that works perfectly fine for this. The problem is that the data in that XML file does not have any IDs/Primary Keys/Foreign Keys whatsoever. XML Source component generates IDs on the fly, and it works perfect for joining the tables, however I will have more XMLs in the future, and the data from there should be appended to existing tables. In that case those IDs that SSIS generates will be duplicates of those that are in the tables already.
Is there a way I can make SSIS generate unique IDs with respect to those that exist in the tables already, to avoid any possible duplicates?