SSIS Basics
This chapter describes SSIS and its role in enterprise business. SSIS is governed by an
object model, and has several important objects.
SQL Server Integration Services
Integrating data into applications or reports is one of the most important, expensive,
and exacting activities in building enterprise data warehousing applications. SQL
Server Integration Services with the acronym SSIS, is a high performance solution
consisting of multiple tools dedicated to this task in MS SQL Server 2005 and is
tightly integrated with the .NET Framework tools. SSIS is a product which has
evolved over time from MS SQL Server 7.0, where it was called Data Transformation
Service (DTS). Although DTS was the forerunner of SSIS, it is not just an
improvement, but an entirely new product, which has all the features of the earlier
tool, but with a vastly improved development interface, an extensible architecture,
enlarged set of tools to address the varied and changing pattern of data in line
with the latest developments in data related technology, looping structures, ease of
integrating with Analysis Services, better management and performance.
ETL that is, extracting, transforming, and loading takes care of all the activities
needed to accomplish data integration. This process consists of extracting data from
a source, transforming the extracted data and then loading the modified data to a
target server to be used by the application.
Pages:
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26