Chapter 3. Extracting and Loading Data
After completing this chapter, you will be able to:
Understand and create connection managers.
Extract and load data from different data sources to different destinations.
Use data sources and data source views to extend the functionality of a regular connection manager.
In Chapter 2, you learned about how to build your first package, and you explored SQL Server Business Intelligence Development Studio (BIDS) and its basic components. In this chapter, you’ll learn how to set up a new Microsoft SQL Server Integration Services (SSIS) project, add a data flow task to extract data from a source, and load the results into a destination. Specifically, you’ll learn how to create and configure a connection manager for ...
Get Microsoft® SQL Server™ 2005 Integration Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
