Is your SSIS package the only source for the tables?
If yes, you can generate the IDs yourself in the package and insert them into the tables.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP