July 1, 2009 at 7:25 am
I have no idea why I am getting error, Because the data I am using does not have any NULLS.
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (80004005): Insert error, column 9 ('Pxxx', DBTYPE_STR), status 10: Integrity violation; attempt to insert NULL data or data which violates constraints.) (Microsoft OLE DB Provider for SQL Server (80004005): Unspecified error)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0
July 1, 2009 at 7:30 am
The data might not be, but if you have a column in the destiantion table that you are not populating during the data pump it can cause this. Is the field 'Pxxx' mapped into the destination? If so what is the transformation used?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply