M01D01 - Simple ETL Solutions with SSIS - Sample

Dinesh Priyankara — Mon, 09 Apr 2007 00:33:16 GMT

April 5, 2007 - Presentation 01 - Sample 01

This sample shows the implementation of simple ETL solution with SSIS.

Instruction
1. Extract the file into your working folder and open the SSIS solution.
2. Configure the Flat file connection to given flat file and OLEDB connection to the local SQL Server. Make sure you have AdventureWorks DB attached to the server.

M01D02 - A Simple BI Case - Sample

Gogula G. Aryalingam — Sun, 08 Apr 2007 18:54:41 GMT

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.

Meeting 01 - Samples

M01D01 - Simple ETL Solutions with SSIS - Sample

M01D02 - A Simple BI Case - Sample

A Simple BI Case - What you can do with SQL Server 2005 to implement Business Intelligence by Gogula Aryalingam