Table of Contents OverviewArchitectureCommunity ResourcesSQL Server "Denali" CTP1 SSIS Wiki PagesSSIS Wiki PagesSee Also
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.
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 for BI (SSDT-BI).
Upgrade and Migration
For a list of additional community resources, go to SSIS Community Resources.
For a list of design patterns, go to SSIS Design Patterns Wiki
Migrate and Deploy SSIS Packages
Design SSIS Packages
Zoltán Horváth edited Revision 59. Comment: Indented the "Dataflow Task" in SSIS Wiki Pages > SSIS Task > List of Tasks.
Zoltán Horváth edited Revision 60. Comment: tried with another indentation of the Dataflow Task
Zoltán Horváth edited Revision 66. Comment: added link to "Execute Package Task" under "SSIS Wiki Pages"
Aalam Rangi edited Revision 74. Comment: Added links to the SSIS Design Patterns Wiki
Very Helpful.............. Thanks
Carsten Siemens edited Revision 87. Comment: Fixed misspelling
I learned something new today. Thanks for this!
Ed Price - MSFT edited Revision 91. Comment: Added See Also link - SQL Server Integration Services Portal
Great job, for all the information on SSIS. Tks