Mass assign components in production order

Dear Experts,

I need to assign around 2000 components to different operations for around 70 production orders. I have only one routing for all FGs. I get SO wise bom which may have new or different parts going to different operations.

Other that creating a BDC , do we have any better option?

Thank you,

Rajib.