Microsoft KB Archive/228933

= FIX: 'Unspecified Error' Message Returned Placing a NULL in a Non-NULL Column =

Article ID: 228933

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q228933



BUG #: 53803 (SQLBUG_70)



SYMPTOMS
When executing a Data Transformation from a SQL Server source table that contains a column with a NULL value to a column in a SQL Server destination table defined as NOT NULL, the following message occurs:

Error at Destination for Row. Error encountered so far in this task: 1. Unspecified error.

Although the behavior is expected, the error message does not supply enough information to resolve the problem.



WORKAROUND
Inspect row described in the error message in the source table to discover which column is being passed as NULL. Inspect the schema of the destination table to discover which column is defined as NOT NULL. Then apply one of the following workarounds:
 * Correct the destination table schema to accept NULL values on the specified column.
 * Ensure that NULL values are not passed to columns defined as NOT NULL.
 * Add a step to the transformation to inspect for NULL values and add a value to be passed to the column(s) defined as NOT NULL.
 * Add a default to the destination table column or columns defined as NOT NULL.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

232570INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.



MORE INFORMATION
The service pack correction for the 'Unspecified Error' is to give a more specific error message under this condition. Passing a NULL to a column defined not to accept NULL values will continue to fail.

After applying SQL Server 7.0 Service Pack 1 or later, the following error message should be returned:

Error at Destination for Row number. Errors encountered so far in this task:. Insert error, column  (' ', ' '), status 10: Integrity violation; attempt to insert NULL data or data which violates constraints. Unspecified error

Additional query words: data transformation services DTS nullable nulls

Keywords: kbbug kbfix KB228933

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.