I have a situation where i need to reproduce a complex SSIS package with varying degrees of differences but for the most part 60% of it is the same across all permutations.
The problem being is each one needs to be recreated from scratch. If any copy and paste is done then it results in METADATA errors when i test in the DEV environment but even more so when i deploy to production.
This quickly turns into a nightmare.
Has any one developed any clever ways to resolve the SSIS METADATA errors that doesn't require either creating each package from scratch or opening, building, saving, and closing each and every task?