BUG: DTS Fails When Importing Table with a Timestamp Column

ID: Q199240

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 53386 (SQLBUG_70)

SYMPTOMS

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

General error -2147217887 (80040E21). Errors occurred

The error occurs regardless of whether the transfer has the "Drop destination objects first" option enabled or the "Append data" option enabled.

WORKAROUND

Here are two ways to work around this behavior:

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.

STATUS

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

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug