SSIS - Variable Sources
Note: The transform and load population should be in two separate processes. This is an example only. Fit the logic to your process.