Here are few scenarios and suggestions.

1. Is the website performing only log reporting? : If the web site is only performing log reporting, then I suppose there is no need...

I suppose to get the data on to the cube you should have had an original database:tables etc.

Use the base tables, and perform an ETL to transform the rows...

Find below the code for getting OWC Excel component in html page. But you will have to pump an XML stream into the OWC component. Also note that OWC used...

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsqlref.chm::/ts_sp_ca-cz_1lpu.htm

As Discussed in this BookS Online URL, use sp_changeobjectowner to change the object owner.

Dont forget to script the permissions, and get the permissions back.

First,

Create a new database -then- Simulate the...