|
|
 M01D02 - A Simple BI Case - Sample
File Details
| Downloads: |
366 |
File Size: |
1.8MB |
| Posted By: |
Gogula G. Aryalingam |
Views: |
168 |
| Date Added: |
Mon, Apr 09 2007 |
|
A Simple BI Case - What you can do with SQL Server 2005 to implement Business Intelligence by Gogula Aryalingam
Instructions:
- Extract the contents of file directly to the D: drive. Ideally a folder named "BI with SQL Server 2005" should be created.
- Attach each of the two .MDF files found inside the "Database Files" folder to SQL Server. This should create (attach) two databases named "Malabar" and "MalabarDW"
- In case D: drive is not available and you extract it to another drive, when you open the "MalabarETL" project, open the "TransferSalesInformation.dtsx" package and edit the appropriate Connection Managers to point to the appropriate Excel and Access files which are housed in the "Data Files" folder.
|
|
|