CODEWITHSUNDEEP
csvssissql-server-2016data-migrationflat-file
Askar
Askar

Reputation: 5854

Regarding executing data flow tasks in a specific order in SSIS

I created 4 Data Flow Tasks as shown in the image in which order I want them to run:

  1. Customers
  2. Locations
  3. Orders
  4. Items

enter image description here

Each data task flow consists of:

  1. Flat File data source
  2. Data Conversion
  3. OLE DB Destination

enter image description here

When I run, according to the Execution Results tab in the image, not in the order I wanted but:

  1. Customers
  2. Items
  3. Locations
  4. Orders

The execution completes successfully though. I was able to check all data successfully inserted into DB.

enter image description here

Questions:

  1. Does sequence of tables migration matter when tables have foreign keys?
  2. If yes, then why the above execution didn't throw any errors?
  3. How to specify the order of execution?

Thanks.

Upvotes: 0

Views: 1269

Answers (2)

Ahmad Gozin
Ahmad Gozin

Reputation: 23

The order is exactly the way you set. but If its important to you to be sure its in specific order, you can set the Constraint to Completion.

i this way the second will not start till the first complete.

Upvotes: 0

Rich
Rich

Reputation: 2279

The order you've specified is the order in which it has actually run. The Execution Results tab is showing them alphabetically.

If you'd like to see the order and prove it to yourself, add some tasks in the sequence to write to a table with datetimes in, or make or inspect a log (using the SSIS Catalog if you're using a Project deployment, or a Log Provider if using Package deployment).

Upvotes: 2

Related Questions