topic Re: A problem with integrity constraint in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/A-problem-with-integrity-constraint/m-p/65089#M18550 Hi,<BR /> <BR /> Try to check the columns of your target table. probably some of your columns should not contain a null value and then you try to insert records with a null value on that particular column. Hope this helps.<BR /> <BR /> regards,<BR /> milton Tue, 18 Aug 2009 09:54:29 GMT milts 2009-08-18T09:54:29Z A problem with integrity constraint https://communities.sas.com/t5/SAS-Procedures/A-problem-with-integrity-constraint/m-p/65088#M18549 Hi guys,<BR /> <BR /> I have encounter a problem in SAS data integration studio 3.4.<BR /> <BR /> The problem is like this. After a transformation, all the data will output into an temp target table. Then I load this data using the table loader into the target table<BR /> <BR /> Before I loaded into the target table, the temp target table has 80000 records.<BR /> <BR /> After I loaded into the target table, the target table has 70000 records.<BR /> <BR /> It is due to:<BR /> <BR /> WARNING: Add/Update failed for data set STG_SEAB.PERSONAL because data value(s) do not comply with integrity constraint _NM0001_. <BR /> (Occurred 498 times.)<BR /> <BR /> WARNING: Add/Update failed for data set STG_SEAB.PERSONAL because data value(s) do not comply with integrity constraint _NM0002_. <BR /> (Occurred 9312 times.)<BR /> <BR /> So how to solve this problem?<BR /> <BR /> Thanks.<BR /> <BR /> Yours Sincerely,<BR /> helphelp Tue, 18 Aug 2009 08:39:09 GMT https://communities.sas.com/t5/SAS-Procedures/A-problem-with-integrity-constraint/m-p/65088#M18549 deleted_user 2009-08-18T08:39:09Z Re: A problem with integrity constraint https://communities.sas.com/t5/SAS-Procedures/A-problem-with-integrity-constraint/m-p/65089#M18550 Hi,<BR /> <BR /> Try to check the columns of your target table. probably some of your columns should not contain a null value and then you try to insert records with a null value on that particular column. Hope this helps.<BR /> <BR /> regards,<BR /> milton Tue, 18 Aug 2009 09:54:29 GMT https://communities.sas.com/t5/SAS-Procedures/A-problem-with-integrity-constraint/m-p/65089#M18550 milts 2009-08-18T09:54:29Z