Microsoft® SQL Server® 2012 Bible

1155

CHAPTER

52

Building, Deploying, and

Managing ETL Workfl ows in

Integration Services

IN THIS CHAPTER

Using New SSIS Features

Understanding Deprecated Features

Performing Basic ETL with SSIS

Constructing Control and Data Flows

Exploring the Full List of Package Elements

Understanding Deployment Models

E

TL stands for Extract, Transform, and Load, and is most commonly associated with data ware-

housing; however, many businesses require ETL processes without ever moving into the realm

of the data warehouse. For example, a call center that processes the insurance claims of hun-

dreds of insurance companies must import each client companies’ location and policy data. That

data must live in both systems, and because both systems almost always have different data sche-

mas, you must perform a constant transform process on the data to achieve proper data integrity

and synchronization. Enter the ETL developer armed with SSIS.

Integration Services offers a lot of ETL bang for the buck in the world of Enterprise ETL tools. The

multitude of new features offered in SSIS in SQL Server 2012 addresses many of the reported com-

plaints about the steep learning curve and the diffi culty of using confi gurations.

c52.indd 1155c52.indd 1155 7/31/2012 10:29:23 AM7/31/2012 10:29:23 AM

http://www.it-ebooks.info