SQL Server Integration Services: Patterns and Practices for the Real World
Learn how you can apply Integration Services to the ETL paradigm in your business.
- By Trey Johnson
Listen to the audio and watch the slides! (Running time: 1 hour, 2 minutes)
SQL Server 2005's Integration Services feature fulfills the core needs of ETL (Extract Transform and Load) within the enterprise. This technology isn't your old Data Transformation Services (DTS), but you can learn new techniques that will make ETL successful for you today. Learn how Integration Services can be applied to the ETL paradigm as well as alternatives, and explore querying of federated data sources. Integrate data mining into the pipeline, and understand the blend of out-of-the-box and custom extensions necessary for Integration Services to work well in your organization. Plus, see various demos that can be applied to your business.