Data Warehouse Debugging Tool
CSDWDbgSrv.exe, a Data Warehouse debugging tool, is included with Commerce Server 2009 R2. This tool lets you see trace output from the OLE DB Provider for Commerce Server 2009 R2. If you append –f traceoutput to the file name, the tool will log all output to a file that has a timestamp appended to the log file name. We recommend that you use the CSDWDbgSrv.exe tool whenever you modify the OLE DB Provider schema.
To run the CSDWDbgSrv.exe tool, open a Command Prompt window, and type the following command:
<drive>:\Program Files\Common Files\Microsoft Shared\Enterprise Servers\Commerce Server\CSDWDbgSrv.exe -f traceoutput
This will create a file whose file name will have 'traceoutput' as a prefix, a time stamp as the suffix, and .txt as the extension. For example, traceoutput-0904-163027-23011.txt would be a trace created on September 4 at 4:30.
You can obtain additional information about import issues with the command:
<drive>:\Program Files\Common Files\Microsoft Shared\Enterprise Servers\Commerce Server\CSDWDbgSrv.exe Set TRACESYNC=T > c:\dtsimport.txt
This will create the file 'dtsimport.txt' in the C: root directory. The file will contain trace information about the import process.