SSIS
Over the next few weeks I am planning to share my experience designing, implementing and deploying an ETL solution done using Sql Server Integration Services (SSIS).
For starters SSIS is a data integration platform rich with components which enable loading, mining, extraction, transformation and consolidation of data. Some features which come out of the box and that make this instantly likeable is its logging feature (text, event, xml, database), ability to work with diverse sets of data (FTP, HTTP, Web Service), event handlers (auditing) and checkpoint restart capability.
Some handy links
SSIS for Beginners, Intermediate, Advanced
SQL Server 2005 Business Intelligence Metadata Samples Toolkit: The two tool kits DependencyAnalyzer, DependencyViewer make this sample worth looking at.
DependencyAnalyzer: a utility that scans SSIS packages and SSAS databases for enumerating metadata (objects, properties and dependencies).
DependencyViewer: GUI program to view the captured dependency data.
Project REAL: Look here for an actual implementation of a dataware house using SSIS.
Managing and Deploying SQL Server Integration Services:
Jamie on SSIS: Excellent blog with lots of information and suggestions working with SSIS
Kirk Haselden: Another excellent blog complementing Jamie's blog above.