Microsoft KB Archive/299675

= FIX: International Characters (DBCS) Corrupted in the Exported XML File from Meta Data Services =

Article ID: 299675

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q299675



BUG #: 351370 (Shiloh_bugs)



SYMPTOMS
When you export a Data Transformation Services (DTS) package in Meta Data Services to XML, if a table used in the DTS package was created by using international characters (DBCS), the exported XML file may not contain the table name.



RESOLUTION
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:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.



Steps to Reproduce Behavior

 * 1) Create a new table with international characters (for example, Japanese or Traditional Chinese characters).
 * 2) Create a new DTS package by using the SQL Enterprise Manager. Expand the Data Transformation Service folder, right-click Local Packages, and then click New Package. A new window titled DTS package opens.
 * 3) On the menu bar, click Connection, point to Select Connection, and then click Microsoft OLE DB Provider for SQL Server. The Connection Properties dialog box opens.
 * 4) Select the name of the database in which the table in step 1 was created from the drop-down combo box, and then click OK.
 * 5) From the Task menu, click Execute SQL Task. The Execute SQL Task Properties dialog box displays.
 * 6) In the SQLStatement text box, type this Transact-SQL statement: SELECT * from table 


 * 1) Click OK.
 * 2) From the Save As menu, click Package.
 * 3) In the Location combo box, click Meta Data Service, and then click OK.
 * 4) Close the DTS package.
 * 5) Expand Meta Data Services in SQL Enterprise Manager.
 * 6) Expand Contents.
 * 7) Expand Microsoft Data Warehousing Framework.
 * 8) Expand Microsoft SQL Server Data Transformation Services.
 * 9) Right-click the name of the DTS package you created in step 6, and then click Export to XML.... When you view the XML file, search for &quot;Select&quot;. You will see that there is no table name used in the SELECT statement.

Keywords: kbbug kbfix kbsqlserv2000sp1fix KB299675

-

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

© Microsoft Corporation. All rights reserved.