Hi all , I need sujjestions on ssis error , iam getting error while loading fact table with foriegn key conflict with dimension,i was unable to predict the cause of error ,

did your dimension data is up to date? I think you are loading data in fact table which has no corresponding PK id in the dimension related table. http://www.rad.pasfu.com

HHi Reza, I did processes the dimension data before loading the fact table,it is up to date,what is the best way to diagnoise the errors files or tables with duplicate data

what is the Task you used in SSIS to load fact table? did you used Analysis Service processing task? what is your error message exactly? paste it here ( you can find it in progress tab in BIDS when you execute package )http://www.rad.pasfu.com

Hi reza, That is my errror [OLE DB Destination [6760]] 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: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_Fact_Sales_1'. Cannot insert duplicate key in object 'dbo.Fact_Sales'.". many thanks

[OLE DB Destination [6760]] 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: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Fact_Sales_DIM_TransactionProduct". The conflict occurred in database "WAREHOUSEDW_newTest2.3", table "dbo.DIM_TransactionProduct", column 'TransactionProductDimension'.".

Hi reza, That is my errror [OLE DB Destination [6760]] 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: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_Fact_Sales_1'. Cannot insert duplicate key in object 'dbo.Fact_Sales'.". many thanks seems you are inserting duplicate record in a fact table. you should avoid it, look at this thread for similar problem and solution provided there: http://www.sqldev.org/sql-server-integration-services/ssis-package-loading-the-duplicate-records-in-fact-laoding-when-rerun-package-15138.shtmlhttp://www.rad.pasfu.com

Please recheck the data you were trying to load. The error message is self-explanatory. “Cannot insert duplicate key in object 'dbo.Fact_Sales” You create PRIMARY KEY for fact table, but you were trying to insert duplicated record. “The INSERT statement conflicted with the FOREIGN KEY constrain ***” The data doesn’t exist in dimension table. You can try to use lookup to check the data. Hope this helps, RaymondRaymond Li - MSFT