When we use the DTS wizard in commerce server 2002 you have the option
to take the query string from the log file. When I check that checkbox
it is not working. So I have unchecked it again. But now I get a error
that the object LinkVallUriQuery and VallUriQuery (or something like
that) can not be found or invalid. I have search in the stored
procedures which the DTS package runs and found in
CSDW_makeMVfactQuerySting (or something like that. I don't now the
exactly names because I have no CS 2002 here at the moment) that the
stored procedure uses 2 tables named VallUriQuery and LinkVallUriQuery
and if I search for the tables in the commerce server data warehouse I
can not found them. The error I get in the last step of the DTS package
(Report preparation). Now I have found a table Storedprocinfo where you
can see which stored procedures will run when you execute the DTS
package. So i have turned off the stored procedure
CSDW_MakeMVFactQuerystring and the package is working again. But this i
not the correct solution I think. So does anyone now what I do wrong
and can not get the Query string from the Log file?? Tanks!!