Se você ainda tem dificuldades para trabalhar com o SQL Server Integration Services (SSIS) do SQL Server 2005, estes artigos são uma ótima oportunidade para aprender a usar o SSIS acompanhando o desenvolvimento de um projeto real de BI.
A primeira parte do projeto inclui a migração de pacotes DTS do SQL Server 2000 para o SSIS do SQL Server 2005 e a segunda parte trata o desenvolvimento de componentes para extrair e transformar os dados de forma a permitir sua carga sobre as tabelas.
A primeira parte do artigo cobre os seguintes tópicos:
Introduction: Project REAL
Phase One Implementation
Upgrade from SQL Server 2000 DTS
Using the Migration Wizard
Migration Wizard Considerations
Beta 2 and Community Preview Release Migration Considerations
Performing a Manual Upgrade
Running SQL Server 2000 DTS Packages Under SQL Server 2005 Integration Services
Lessons Learned While Developing SQL Server 2005 Integration Services Packages
Implementation Best Practices
Property Expressions
Avoid the Pains of a Restart After Failure
Precedence Constraint Editor
Package Execution
Analysis Services Partition Cloning
Extend the DTS Data Flow Tasks Using Custom Source and Transformation Components
Advanced Editors
Performance Tips and Tricks
Issues Encountered
Product Enhancement Requests
Conclusion
A parte 2 do artigo cobre os seguintes tópicos:
Introduction: Project REAL
Phase One Implementation
Core ETL Processing
Why Custom Components?
Proposed Design for Loading the TLog Data into the Data Warehouse
SSIS Object Model and Pipeline Components
Implementation of the Custom Components
The Custom Source Adapter
The Custom TLog Transformation
Deployment
Generating a Strong Name for the Assembly
Compiling the Task
Moving the Task to the Appropriate Directories
Adding the Task to the SSIS Toolbox
Creating the Package Using the Custom Components
Debugging
Lessons Learned
Conclusion
For more information
Links Relacionados:
SQL Server 2005 Integration Services, Part 1: Lessons from Project REAL
SQL Server 2005 Integration Services, Part 2: Developing Custom Components for Project REALProject REALBusiness Intelligence in Practice