December 4, 2007 at 11:49 am
i have two tables
owner - server one
entity- server two
am using ssis to input the data into different destinations(sql tables) in server two
am using UNION ALL task to have a single data set from these two tables(owner and entity)
then i use multitask to input that data into different destinations.
but it keeps giving me this error message
"[its_name [28965]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unspecified error".
"[its_name [28965]] Error: There was an error with input column "entity_key" (29283) on input "OLE DB Destination Input" (28978). The column status returned was: "The value violated the integrity constraints for the column.".
"[its_name [28965]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (28978)" failed because error code 0xC020907D occurred, and the error row disposition on "input "OLE DB Destination Input" (28978)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
its_name is one of the destination tables. It has a FK column(entity_key) which is the Primary key of the source (entity table)
Any help on this please ???
December 5, 2007 at 12:58 am
Probably your package try to add record with invalid data in foreign key column (value does not exists in referenced table primary key).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply