I'm trying to set up an import form live database to our development database.
I trying to do this using SSIS, but the import is failing because of constraints.
E.g. I have the following tables:
Importing Customers and Products is fine, because they do not depend on anything. But when importing OrderLines it fails because the Order is not yet created.
How do I change the order of how SSIS imports tables?
Or maybe I'm not supposed to use foreign key constraints?