The statement has been terminated. (Microsoft OLE DB
Provider for SQL Server (80040e2f): INSERT statement
conflicted with COLUMN FOREIGN KEY
constraint 'FK_fctSales_dmProduct'. The conflict occurred
in database 'MgkOlap', table 'dmProduct',
column 'item_code'.)
Package failed because Step 'DTSStep_DTSExecuteSQLTask_8'
failed.

I can only presume that this is an error message you are receiving and that
you want help as there would seem to be no preamble to the post. A small
explanation is helpful but in this case the error message says it all.

In your destination You have a fact table which you are trying to insert
into. The fact table has FK relationships with the dimensions. The
dimension you are having trouble with is dmProduct. You are trying to
insert a value into the FK in the fact table that does not relate to
anything in the dimension

Example

CREATE TABLE Parent (col1 int primary key)

CREATE TABLE CHILD (col1 int primary KEY, ParentCol1 int references
Parent(col1))

GO



INSERT CHILD(Col1, ParentCol1) VALUES(1,1)

**ERROR**

INSERT statement conflicted with FOREIGN KEY constraint
'FK__CHILD__ParentCol__33D4B598'. The conflict occurred in database 'pubs',
table 'Parent', column 'col1'

**--



Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jael" <anonymous (AT) discussions (DOT) microsoft.com> wrote