Framework Design, Agile Coach, President Oklahoma City Developers Group, Microsoft MVP C#, TDD, Continuous Integration, Patterns and Practices, Domain Driven Design, Speaker, VB.Net, C# and Sql Server
If you want to learn more about SSIS, check out this article:SQL Server 2005 Integration Services: Lessons from Project REAL. SSIS (Sql Server Integration Services) is the replacement for DTS packages.
In Project REAL we are using large volumes of real data and scenarios from real companies to implement business intelligence systems using early releases of Microsoft SQL Server 2005. In the process, best practices are being developed and potential problems uncovered. This article reports some of the lessons learned while working on the data extraction, transformation, and loading (ETL) portion of the first phase of Project REAL.
Some of the topics covered in this article include:
- Upgrading from Sql Server 2000 DTS
- Issues when using the upgrade/migration wizard
- Manually upgrading DTS to SSIS
- Lesssons learned developing SSIS packages
- Implementation best practices
- Package execution
- Tips and tricks
- And much more!
The article may look lengthy (61 printed pages), but it is full of great content with tons of screenshots too.
About Raymond Lewallen
Working primarily in the public sector during his career, Raymond has designed and built several high profile enterprise level applications for all levels of the government. Raymond now works as a solutions architect for EMC. Raymond is an agile coach, Microsoft MVP C# and also president of the Oklahoma City Developers Group and Oklahoma Agile Developers Group. Raymond spends a lot of his time learning and teaching such things as Test Driven Development, Domain Driven Design, Design Patterns and Extreme Programming practices and principles, to name a few. Raymond is also an advocate of Alt.Net. Raymond is primarily a framework guy, so don't ask him anything about UI :)
