We are trying to load data into a Link that references multiple Hubs but the batch is trying to process the Link before some of the Hubs. I would have assumed that since there are FK constraints from the Link Hub HK's to the Hub HK's that the batch would have ordered the SSIS package executions to process the Hubs before the Link.
This doesn't seem to be the case and we are running into FK violations when trying to insert the main Link records.
We've tried to use the "Depends On Object" field in the SQL Override section of the object that sources the Link but it doesn't seem to affect the ordering of the package executions in the batch.
The only option we see to avoid the errors is to use the Infer Link Hub setting but we would prefer not to enable this for all links to avoid additional unnecessary processing.
Is there another solution to this?