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

Full Stack Hands-On Development with .NET

In the fast-paced realm of modern software development, proficiency across a full stack of technologies is not just beneficial, it's essential. Microsoft has an entire stack of open source development components in its .NET platform (formerly known as .NET Core) that can be used to build an end-to-end set of applications.
.NET-Centric Uno Platform Debuts 'Single Project' for 9 Targets

"We've reduced the complexity of project files and eliminated the need for explicit NuGet package references, separate project libraries, or 'shared' projects."
Creating Reactive Applications in .NET

In modern applications, data is being retrieved in asynchronous, real-time streams, as traditional pull requests where the clients asks for data from the server are becoming a thing of the past.
AI for GitHub Collaboration? Maybe Not So Much

No doubt GitHub Copilot has been a boon for developers, but AI might not be the best tool for collaboration, according to developers weighing in on a recent social media post from the GitHub team.
Visual Studio 2022 Getting VS Code 'Command Palette' Equivalent

As any Visual Studio Code user knows, the editor's command palette is a powerful tool for getting things done quickly, without having to navigate through menus and dialogs. Now, we learn how an equivalent is coming for Microsoft's flagship Visual Studio IDE, invoked by the same familiar Ctrl+Shift+P keyboard shortcut.