SQL Server Integration Services: Patterns and Practices for the Real World -- Visual Studio Magazine

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
05/01/2006

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.

Printable Format

comments powered by Disqus

Featured

.NET 11 Preview 5 Focuses on Performance, Productivity and Safer Code

.NET 11 Preview 5 focuses on under-the-hood runtime performance gains, streamlined APIs and language features that reduce boilerplate, plus built‑in security checks and incremental ASP.NET Core and EF Core improvements aimed at everyday developer productivity.
VS Code 1.124 Focuses on Agent Autonomy and Parallel Sessions

Microsoft's June 2026 VS Code update turns on Autopilot by default and adds background sending for agent sessions.
Developing Agentic Systems in .NET: From Concept to Code

ZioNet founder Alon Fliess previews his Visual Studio Live! San Diego session on building true agentic systems in .NET -- covering the cognitive loop, MCP tool integration, multi-agent orchestration and enterprise hosting and governance with the Microsoft Agent Framework.
Mastering AI Development and Building AI Apps with GitHub Copilot

Two Microsoft experts explain how GitHub Copilot is evolving from a coding assistant into a broader platform for building, customizing and testing AI-powered developer workflows.