Microsoft KB Archive/238673

= BUG: Package Execution Can Fail if Target Table Has an Identity =

Article ID: 238673

Article Last Modified on 10/31/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q238673



BUG #: 56157 (SQLBUG_70)



SYMPTOMS
If your destination table has an identity property and you have not selected the Use fast load option but have selected Enable identity insert in your Data Transformation Services (DTS) package before you execute the package, the package will fail with the following error message in the SQL Server 7.0 licensed version:

Error at Destination for Row number 1. Errors encountered so far in this task: 1.

Errors occurred.

If you execute the same package in SQL Server 7 Service Pack 1, you will get:

Error at Destination for Row number 1. Errors encountered so far in this task: 1.

Insert error, column 1 ('ColumnName', DBTYPE_I4), status 9: Permission denied.



WORKAROUND
The problem can be avoided by selecting both Use fast load and Enable identity insert during DTS operations. Both options are found on the Advanced tab of the Data Transformation Properties window.

NOTE: If you have triggers defined with your destination table, the triggers will be ignored when Use fast load is enabled.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB238673

-

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

© Microsoft Corporation. All rights reserved.