Microsoft KB Archive/199240

= BUG: DTS Fails When Importing Table with a Timestamp Column =

Article ID: 199240

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q199240



BUG #: 53386 (SQLBUG_70)



SYMPTOMS
When you use the "Copy table(s) from the source database" option of the Data Transformation Services (DTS) Import wizard to transfer a table with a timestamp column, DTS fails with the following error:

General error -2147217887 (80040E21). Errors occurred



CAUSE
This error occurs if the destination table is also defined with a timestamp column. The error occurs regardless of whether the transfer has the "Drop destination objects first" or "Append data" option enabled.



WORKAROUND

 * Use DTS and specify "Use a query to specify the data to transfer". The query should exclude the timestamp column.

-or-
 * Use DTS and specify "Transfer objects and data between SQL Server 7.0 databases" and then specify which table you want to transfer.

-or-
 * Define the destination table to use binary(8) for the datatype for the column which will contain the timestamp.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.



MORE INFORMATION
The generic error message that is returned does not indicate the true cause of the failure. Note that none of the workarounds allow you to import a timestamp into a destination column that is defined using the timestamp datatype. In order to transfer a timestamp column, the destination column must be defined as binary(8).

Keywords: kbbug kbpending KB199240

-

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

© Microsoft Corporation. All rights reserved.