SSIS Tutorials/ Hands-On Labs Business Intelligence:
SSIS Virtual Lab: After completing this lab, you will be better able to:
1. Create a SQL Server 2005 Integration Services (SSIS) package
2. Create an SSIS package project Monitor the progress of an SSIS package
3. Log results from an SSIS package to both a text file and the Windows Event log
Hands-on Training for SSIS (SQL Server Integration Services) Contains a Microsoft Word lab Document, sample files to process, and a sample DB, all of which support a series of exercises which guide a reader/user through step by step creating SSIS (SQL Server Integration Services) packages. Lab document includes commentary and by completion of the exercises a user will have a good understanding of what can be accomplished with SSIS as well as how to create some simple SSIS packages.
SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components This manual is was presented as a hands on training lab which walks users through Step by Step, creating a sample Custom Component\Transformation for SQL Server Integration Services (SSIS).
Downloads
SSIS Downloads SQL Server Integration Services (SSIS) Downloads contains links to various MSDN downloads, all related to SSIS. The downloads include training material, sample SSIS packages, and other technical material intended to help users learn and use SSIS.
http://msdn2.microsoft.com/en-us/sql/aa336314.aspx
Business Intelligence Architecture and Design Guide
Microsoft's patterns & practices group gives you prescriptive guidance on how to overcome architectural challenges and design issues when building Business Intelligence solutions using the Microsoft platform. Business Intelligence Architecture and Design Guide SQL Server 2005 Samples and Sample Databases (February 2007)
Microsoft SQL Server 2005 Service Pack 2
