Book Image

Applied Architecture Patterns on the Microsoft Platform

Book Image

Applied Architecture Patterns on the Microsoft Platform

Overview of this book

Table of Contents (20 chapters)
Applied Architecture Patterns on the Microsoft Platform Second Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Summary


SSIS is a highly reliable, proven tool for data integration. It can be used in different ETL scenarios, such as during data migration from a legacy database to a new one or when building a data feed for a data warehouse. Over the years, SSIS has been improved, new features have been added, and the development interface has become a truly enjoyable one.

We will talk more about SSIS in Chapter 10, Data Exchange Patterns. In the next chapter, we will present another integration tool, Microsoft BizTalk Server. Where SSIS is a valuable tool for data integration solutions, BizTalk is more helpful when there is a need for application integration. Read more about integration architecture in the next few chapters.