Insert Error on SQL DTS Import
Posted on 2007-10-18
SQL Server 2000 (Working with Test Database)
Pump Data From: StageFactCustSales to FactCustSales
Problem field: CustomCategoryDesc varchar(25) NOT NULL
I have a very large dts package that fails during the data pump step. It takes data from stage tables and imports them into fact tables.
The tables are identical except the stage table does not have an identity defined whereas the fact table does. Here is the error I am receiving:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: The number of failing rows exceeds the maximum specified.
Insert error, column 26 ('CustomCategoryDesc', DBTYPE_STR), status 10: Integrity violation; attempt to insert NULL data or data which violates constraints.
The source data (StageFactCustSales) in the CustomCategoryDesc field does not have any <NULL> values, it does have empty values though (where CustomCategoryDesc = ""). To my understanding empty strings are not considered NULLS (correct me if I'm wrong).
Lord knows I've been searching to see if anyone else has had the same problem and how it was resolved. I have only found one other similar issue; however it was regarding an identity column and this is not the same instance since CustomCategoryDesc is not an identity column.
**We even had a contractor come in and spent 8 hours trying to discover our problem to no avail. And yes, he still made $85 an hour.
Kudos to anyone who can offer suggestions!