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

MORE INFORMATION

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 <name of table created in step 1>
   
   
7. Click OK.
8. From the Save As menu, click Package.
9. In the Location combo box, click Meta Data Service, and then click OK.
10. Close the DTS package.
11. Expand Meta Data Services in SQL Enterprise Manager.
12. Expand Contents.
13. Expand Microsoft Data Warehousing Framework.
14. Expand Microsoft SQL Server Data Transformation Services.
15. 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 "Select". You will see that there is no table name used in the SELECT statement.