Summary

Integration Services provides a wealth of resources for accessing data from various sources in various forms. The connection managers make it possible to access resources in a consistent and central location, making it easy to manage and configure packages. There are three categories of connection managers. Those that connect to data servers, those that connect to network services and those that return file system paths for accessing folders and files. Data sources and Data Source Views are two new technologies that make it easy to abstract the details of source data from the querying clients.