Databases Reference
In-Depth Information
Summary
Integration Services provides the infrastructure for all sorts of automated tasks
from data cleansing, data split to data merging. In this chapter you learned that
a package must have a control flow and may also have data flows; the control
flow is represented by tasks and containers, which are connected by preced-
ence constraints. These precedence constraints determine the fate of a control
flow after each step is completed. The precedence constraint can be an ex-
pression that leads to a success or failure condition, or the constraint can be
set to "completion" without further consideration for continued control flow.
Finally, you learned how to import packages into Integration Services using
SSMS and create scheduled jobs of packages using SQL Server Agent.
In the previous chapter summary, you were promised a wonderful synergy
between Integration Services and Analysis Services, and from the section on
"Creating Integration Services Packages for Analysis Services Operations" to
"Automating SSIS packages," you got it! The fun is not over, because in the
next chapter
,
you learn about yet another profound and cool form of product
synergy. Only this time it is about integrating Business Intelligence with Report-
ing Services. There is some amazing stuff in store, like designing static and
ad-hoc reports on top of UDM. Don't miss it!
Search WWH ::
Custom Search