When i use ssis to import data from oltp to data market (using a .dtsx file) an error raise in data flow, i find the detail in log file:
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E2F Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_DimPlant_DimCountry". The conflict occurred in database
"MaxMinManufacturingDM", table "dbo.DimCountry", column 'CountryCode'.".
but is there a way to find which row cause the error? Thanks a lot.
View Complete Post