Chapter 10. The Stock Connection Managers

IN THIS CHAPTER

Connection Manager Concepts

Creating Connection Managers

Stock Connection Managers

Data Sources and Data Source Views

“IF IT’S NOT SCOTTISH, IT’S CRAP!”—BILL BAKER

Connection Manager Concepts

Connection managers are a new object type in Integration Services. They are fundamentally different from Data Transformation Services Connection objects, yet very similar in function. There are also a lot more connection managers because of a fundamental shift in the way connections are used in Integration Services. This chapter explains the concepts behind connection managers and then describes each of the stock connection managers.

Connection Managers

Integration Services has an object ...

Get Microsoft SQL Server 2005 Integration Services 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.