June 2007
Beginner to intermediate
480 pages
12h 30m
English
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 ...
Read now
Unlock full access