DTS Package Integrity violation; attempt to insert NULL data or data which violates constraints

最近做项目，需要从excel和csv中导数据到SQL中，因为数据可能会重新更新，
所以，决定用SQL的DTS，但是使用过程中，针对某个column用ActiveX来拷贝数据，
并测试是可以的，但是在执行DTS的时候，提示如下错误

The number of failing rows exceeds the maximum specified.

Insert error, column 37 ('UOMCodeWht', DBTYPE_STR), status 10:  Integrity violation; attempt to insert NULL data or data which violates constraints.

Insert error, column 36 ('ProductWeigh', DBTYPE_NUMERIC), status 10:  Integrity violation; attempt to insert NULL data or data which violates constraints.

Insert error, column 4 ('ProductPrice', DBTYPE_NUMERIC), status 10:  Integrity violation; attempt to insert NULL data or data which violates constraints.

Insert error, column 3 ('ProductDesc', DBTYPE_STR), status 10:  Integrity violation; attempt to insert NULL data or data which violates constraints.

Insert error, column 2 ('ProductNumber', DBTYPE_STR), status 10:  Integrity violation; attempt to insert NULL data or data which violates constraints.

Insert error, column 1 ('ActionCode', DBTYPE_STR), status 10:  Integrity violation; attempt to insert NULL data or data which violates constraints.

未指定的错误

随即检查未发现错误，数据都是对的，但是就是有错误
上网百度一下，对这个问题讨论的少之又少，就自己琢磨：
发现出问题的字段都是我设置了非空的字段，把表要求非空的字段改回来，允许为空，ok搞定。