Article ID: 295668 - View products that this article applies to.
This article was previously published under Q295668
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 the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )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.
Contact us for more help
Connect with Answer Desk for expert help.