Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Service Oriented Architecture: An Integration Blueprint

You're reading from   Service Oriented Architecture: An Integration Blueprint For SOA professionals this is the classic guide to implementing integration architectures with the help of the Trivadis Blueprint. Takes you deep into the blueprint‚Äôs structure and components with perfect lucidity.

Arrow left icon
Product type Paperback
Published in Jun 2010
Publisher Packt
ISBN-13 9781849681049
Length 240 pages
Edition 1st Edition
Arrow right icon
Toc

Microsoft SQL Server Integration Services


Microsoft SQL Server Integration Services (SSIS) is a comprehensive data integration platform that is used to transport, call, transform, and consolidate information from disparate sources and to upload it to several different systems. It is the successor to Data Transformation Services (DTS).

The SSIS is primarily intended for data integration tasks.

The following diagram shows the components of Microsoft SQL Server Integration Services in the integration blueprint:

The following table holds a description of the components of SQL Server Integration Services, as shown in the preceding diagram:

Component

Description

Connection Managers

A Connection Manager is a logical representation of a connection.

SQL Server Integration Services provides a variety of different connection managers that packages can use to create connections with a range of data sources and servers.

The following connection types are supported, among others: ADO, ADO.NET, Excel...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime