SQL Server Integration Services (SSIS)
Table of Contents
Overview
SQL Server Integration Services (SSIS) is Microsoft's Extract, Transform, Load (ETL) tool and is provided with SQL Server. SSIS provides a rich set of built-in tasks, containers, transformations, and data adapters that support the development of business applications. Without writing a single line of code, you can create SSIS solutions that solve complex business problems using ETL and business intelligence, manage SQL Server databases, and copy SQL Server objects between instances of SQL Server.
For an overview of the typical uses of SSIS, see Typical Uses of Integration Services .
For product installation, videos, and Books Online topics, see the SQL Server 2012 Resource Center .
For the latest downloads, articles, samples, and videos from Microsoft and the community, visit the Integration Services page on MSDN .
Architecture
This architecture diagram is true as at November 2009
The runtime environment of SSIS consists of 2 engines, the Runtime Engine and the Dataflow Engine. A package consists of tasks (one of which is the all-important Dataflow Task) and containers. The development tool for SSIS is Business Intelligence Development Studio ([[articles:Business Intelligence Development Studio (BIDS)|BIDS]]). In SQL Server 2012, BIDs is replaced with SQL Server Data Tools.
Community Resources
Connectivity
- Connecting to MySQL from SSIS
- Writing to a MySQL Database from SSIS
- SSIS Resources (Samples, books, tutorials ...)
- Optimized Bulk Loading of Data into Oracle
Upgrade and Migration
- SQL Server 2008 Migration White Papers (Informix, MySQL, Oracle, Sybase)
- 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
For a list of additional community resources, go to SSIS Community Resources.
For a list of design patterns, go to SSIS Design Patterns Wiki
Không có nhận xét nào:
Đăng nhận xét