CODEWITHSUNDEEP
ssisreferential-integrityself-referenceself-referencing-table
Mel
Mel

Reputation: 3128

how to import a table with a self relationship

I have the following table:

EntityId - PK
Label
ParentEntityId - FK

ParentEntityId is joined to EntityId of the same table. now I am having problems importing data to this table using SSIS because of instances where the parent entities haven't been imported yet and so I get a FK constraint violation. I'm probably missing something obvious.

Upvotes: 2

Views: 597

Answers (1)

grapefruitmoon
grapefruitmoon

Reputation: 3008

You can disable the foreign key prior to loading the data, then re-enable it after loading completes, both using T-SQL.

Eg - to disable - ALTER TABLE yourTableName NOCHECK CONSTRAINT yourConstraintName

To re-enable - ALTER TABLE yourTableName WITH CHECK CHECK CONSTRAINT yourConstraintName

Upvotes: 2

Related Questions