Microsoft KB Archive/324149

= How To DTS Import Transaction Database Custom Data to Data Warehouse =

Article ID: 324149

Article Last Modified on 7/1/2004

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition

-



This article was previously published under Q324149



SUMMARY
A Transaction DTS task does not export to the Datawarehouse database any new fields or new columns that you add to OrderGroup, OrderGroupAddress, OrderFormHeader, or OrderFormLineItems.



MORE INFORMATION
There are four Transaction tables where the Transaction DTS locates data. These are OrderGroup, OrderGroupAddress, OrderFormHeader, and OrderFormLineItems.

If you add fields or columns to these tables, Transaction DTS may not recognize them. To export the data in those additional custom columns to the DataWarehouse database, do the following:   For a new field in any of the four Transaction tables, add an entry in the TransDimension Table (located in the Commerce transaction database) that has the RequiredDim column set to 1.

For example, if you add a custom column named TaxPercentage to the OrderformHeader table, an entry should be added to the Transdimension table as in the following example: DimensionName FieldName      CategoryName    KeyField RequiredDim TaxPercentage TaxPercentage  OrderFormHeader  0        1

 After this change, you can use the Transaction DTS to import data in the custom column TaxPercentage into the Data Warehouse.

Additional query words: plutonium, Thorium, Transaction Database, Data Warehouse, DTS import, Commerce Server

Keywords: kbhowto kbfix kbnofix kbpending KB324149

-

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

© Microsoft Corporation. All rights reserved.