Справочник Пользователя для Wiley Professional Microsoft SQL Server 2008 Integration Services 978-0-470-24795-2
Модели
978-0-470-24795-2
Welcome to SQL Ser ver
Integration Ser vices
SQL Server Integration Services (SSIS) is the anchor in a trilogy of products that make up the
Microsoft SQL Server Business Intelligence (BI) platform. SSIS along with Analysis Services and
Reporting Services round out a platform that clearly puts Microsoft on the map in the enterprise
Business Intelligence arena. In its simplest form, SSIS is an enterprise - level extract, transform, and
load (ETL) development tool. However, SSIS is not just a fancy wrapper around an import wizard.
In a drag - and - drop development environment, ETL developers can snap together intricate
workflows and out - of - the - box data - cleansing flows that rival custom coding and expensive third -
party tools. For your edge cases, the model is easily extensible and custom components can be
developed in .NET languages to simply snap into the framework. However, custom coding most
likely will not even be necessary. With the latest version of SSIS, novice developers can use the
embedded Visual Studio Tools for Applications (VSTA) development environment to custom code
workflow tasks and data pipeline transformations in VB or C# .NET languages.
Microsoft SQL Server Business Intelligence (BI) platform. SSIS along with Analysis Services and
Reporting Services round out a platform that clearly puts Microsoft on the map in the enterprise
Business Intelligence arena. In its simplest form, SSIS is an enterprise - level extract, transform, and
load (ETL) development tool. However, SSIS is not just a fancy wrapper around an import wizard.
In a drag - and - drop development environment, ETL developers can snap together intricate
workflows and out - of - the - box data - cleansing flows that rival custom coding and expensive third -
party tools. For your edge cases, the model is easily extensible and custom components can be
developed in .NET languages to simply snap into the framework. However, custom coding most
likely will not even be necessary. With the latest version of SSIS, novice developers can use the
embedded Visual Studio Tools for Applications (VSTA) development environment to custom code
workflow tasks and data pipeline transformations in VB or C# .NET languages.
When we put together the first edition of this book, we were blown away by the new architecture
and capabilities of SSIS. SSIS was a big change from the Data Transformation Services (DTS)
product that it replaced and there has been much to learn. Since the first edition of SSIS, we have
collectively racked up many years of experience converting older DTS packages and mindsets over
to using SSIS, and trust us when we say that no one who ’ s made the change is asking to go back.
We ’ ve learned some things, too. If you run into an issue getting up and running, converting older
packages, or creating new ones, we ’ ve probably run into that issue too and have a solution for you
here in this book. This book is a new edition and a whole new book. Nothing was sacred in this
rewrite because we really dug in to put the last few years of experience working with this product
back into these pages. We think the result is worth it and this edition will make your experience
with SSIS a more productive one. This chapter starts from the beginning and provides an overview
of SSIS, describes where it fits within the BI product platform, and ETL development in general.
and capabilities of SSIS. SSIS was a big change from the Data Transformation Services (DTS)
product that it replaced and there has been much to learn. Since the first edition of SSIS, we have
collectively racked up many years of experience converting older DTS packages and mindsets over
to using SSIS, and trust us when we say that no one who ’ s made the change is asking to go back.
We ’ ve learned some things, too. If you run into an issue getting up and running, converting older
packages, or creating new ones, we ’ ve probably run into that issue too and have a solution for you
here in this book. This book is a new edition and a whole new book. Nothing was sacred in this
rewrite because we really dug in to put the last few years of experience working with this product
back into these pages. We think the result is worth it and this edition will make your experience
with SSIS a more productive one. This chapter starts from the beginning and provides an overview
of SSIS, describes where it fits within the BI product platform, and ETL development in general.
c01.indd 1
c01.indd 1
8/28/08 12:01:13 PM
8/28/08 12:01:13 PM
COPYRIGHTED MATERIAL