vega805 (7/27/2016)
Ok but through SSIS right? Is this via adding an execution task? Where between the source and destination object within the task to you place such a execution task?
Your package can contain multiple dataflows.
Or you can have multiple packages, one for each dataflow, and run them one after another from a master control package.
These multiple dataflows should run in logical order, such that the tables which are populated first are the ones whose values are the target of FK constraints.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.