Database Reference
In-Depth Information
CHAPTER 4
SQL Server Source Patterns
In the first section of this topic, we looked at patterns focused on the control flow area of
SQL Server Integration Services, including metadata, workflow execution, and script-
ing. The second section focuses on the data flow area of SQL Server Integration Ser-
vices. This and the following chapters will discuss source, transformation, and logging
patterns in the pipeline area of an Integration Services package.
Integration Services supports a wide variety of sources, including SQL Server,
Oracle, and SAP. In addition, developers and third-party vendors have the ability to cre-
ate custom sources for providers not included out-of-the-box. This technology-agnostic
approach creates a very flexible system for loading all sorts of data. Even with all of the
potential sources, loading data into or out of a SQL Server database is a very common
occurrence, since a company that owns Integration Services typically uses all Microsoft
products.
This chapter discusses different patterns associated with using SQL Server as a
source. Due to the common occurrence of SQL Server databases in shops using Integra-
tion Services, we have a defined set of patterns for extracting data from SQL Server.
Specifically, we will look at the best way to connect to a SQL Server database, how to
choose the data you will use, and how to more easily use the rest of the data flow's ob-
jects. Finally, we will look at a new component in SQL Server Denali that helps jump-
start your development when connecting to any source.
Setting Up a Source
Search WWH ::
Custom Search