FIX: Transaction Replication to DB2 Subscribers Incorrectly Map Tinyint Data Type if You Use DTS to Transform Published Data

This article was previously published under Q295668
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 235175( SHILOH_BUGS)
When you use SQL Server 2000, you can create Data Transformation Services (DTS) packages to transform the data at the publisher before replicating it to the subscribers. If any of the published tables have a column with the tinyint data type, and the subscriber is DB2 (heterogeneous subscriber), the tinyint column is incorrectly mapped on the subscriber.

If replication is set up without transforming the published data by using DTS, the problem with data type mapping does not occur.
Static data type mappings are used for data type name and precision matching (based on the data type name that should be the same and destination precision should also be the same or more than the source precision). If a strict match of static mappings (based on name and precision) is not found, the destination server is queried to obtain the mappings dynamically.

If you use the Transform Publish Data Wizard (in case of Transformable subscriptions), the static mapping fails due to a precision mismatch and the destination server (DB2) is not interrogated for precision, which may cause replication to fail.
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in theMicrosoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
To avoid the problem modify the destination table schema in the Transform Publish Data Wizard.
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.

Article ID: 295668 - Last Review: 01/16/2015 22:24:20 - Revision: 3.2

Microsoft SQL Server 2000 Standard Edition

  • kbnosurvey kbarchive kbbug kbfix kbsqlserv2000sp1fix KB295668