Home Forums SQL Server 2008 T-SQL (SS2K8) Stubborn FK doesn't want to play nicely during insert statement RE: Stubborn FK doesn't want to play nicely during insert statement

  • SQL_Enthusiast (5/10/2013)


    Sorry Lynn

    My COMMENT table (original table in DB) and TEMP_COMMENT are indentical in fields and data types. COMMENT has the FK on it while TEMP_COMMENT has no FK's or PK at all. It's built from an SSIS package that uses data from another system, transforms it, and places it TEMP_COMMENT where it waits for execution to be pushed into COMMENT...

    I have attached a spreadsheet that has test data from my system, but in reality, it's identical to what TEMP_COMMENT will have in it after the SSIS packs loads it.

    I don't see any foreign keys defined on TEMP_COMMENT.