DW/A Class Creation Script from Webcast

Three new Data Warehouse WebCast published!

Commerce Team Blog — Fri, 03 Nov 2006 20:34:37 GMT

We added three new webcasts as part of a series on extending the Data Warehouse. Here are the details,

re: DW/A Class Creation Script from Webcast

Willian Leite — Fri, 24 Nov 2006 02:04:55 GMT

Hi Alan,

I watched your webcast and I developed the Classes and Views for my Weekly Typed Properties in my Purchase Orders(after do the OrderObjectMappings.xml).

All this works fine in my Commerce Developer Environment (WebServer and SQL Server in the same machine). Now I have to do this in an Enterprise Cenario.

The DTS Import Wizard fails in the start, showing this message : "Faild to retrive DTS Task Information". In my cenario I have 2 WebServer (ProductionServer and StagingServer) and two SQL Server 2K5 (Commerce DataBase and DW/BI Database).

In the WebServer I dont have any SQL Server installed.

What I need to run the DTS Task in this environment?

re: DW/A Class Creation Script from Webcast

akfaulkner — Wed, 29 Nov 2006 22:38:30 GMT

You need to install Commerce Server on the machine that you plan to run the DTS Task on. So you need to have Sql Server installed and Commerce Server installed on that machine in order to run the DTS task.

Hope this helps and if you have additional questions, I would prefer you to post those in our forums here:

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=294&SiteID=1

Hope this helps!

Alan

re: DW/A Class Creation Script from Webcast

Willian Leite — Thu, 30 Nov 2006 17:44:46 GMT

Hi Alan,

To solve my problem I deleted and re-install the DW in default instace on SQL 2K5.

In my first installation all Database were installed in Named Instances, and I did the same to the relational DW database.

Now I have the relation DW and the analysis Databases on default instances and all works fine.

Thankz for your help,

See you in the Forum.

So it goes

gamonie — Wed, 11 Apr 2007 05:01:10 GMT

I haven't gotten much done these days. So it goes. What can I say? I've just been letting everything pass me by. Basically not much going on lately, but it's not important. I've basically been doing nothing worth mentioning.