Order table is not getting populated

The data warehouse Order table is not getting populated when the Load DTS package is run. THis means the OrderEvents cube is also empty. I understand the Report Preparation DTS Task within the Load DTS package is supposed to populate the OrederEvents cube. NO errors are generated. Does anyone have any ideas on what to examine or change?

[339 byte] By [GL2] at [2008-2-10]

«« Simplest way to move a site collection to another server?
»» Converting nchar to int (or numeric/decimal)

# 1

I would suggest that you run a SQL trace while running the imports and the prepare reports tasks. To get the finest level of granularity, run the tasks one at a time.

The CS DW also has a trace tool called csdwdbgsrv.exe. This tool can be found in the directory Program Files\Common Files\Microsoft Shared\Enterprise Servers\Commerce Server. You invoke this tool by specifying a file to capture the output: 'csdwdbgsrv -f trace'. This will create a file in the current directory with trace as the prefix, a time stamp as the rest of the file name and .txt as the file extension. The output of this file might also hold a clue.

BrianBlum-MSFT at 2007-10-3 >

Commerce Server

Commerce Server 2002 and Earlier

Commerce Server Hot Topic

Commerce Server New Topic

Commerce Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech