Hi, all.
For the past few days, I've been trying to use SSIS to migrate data in tables from a SQL Server database to an Oracle database. I need to retain foreign key constraints while doing it. I'm not in a position to remove foreign key constraints, then add them back.
The problem is that each of the foreign keys I'm using are newly generated GUIDs (created by SSIS).
Example:
I have two tables, "ShipClass" and "Ship". ShipClass contains a foreign Key pointing to Ship. That means the Ship table is loaded first, then ShipClass.
In the first dataflow, Ship is loaded appropriately in its' table - with a new Guid for its' foreign key field. ShipClass is loaded next, but the column containing the foreign key pointing to Ship always has a newly generated Guid.
The problem:
ShipClass has a FK relationship to Ship - both of their Guids absolutely have to be the same. I need a way to preserve foreign key constraints when I'm loading two different tables in SSIS.
I can't figure out how to do this. Can I get some help?