| title | Extract, transform, and load data for SQL Server on Linux | Microsoft Docs |
|---|---|
| description | |
| author | sanagama |
| ms.author | sanagama |
| manager | jhubbard |
| ms.date | 03/17/2017 |
| ms.topic | article |
| ms.prod | sql-linux |
| ms.technology | database-engine |
| ms.assetid | 9dab69c7-73af-4340-aef0-de057356b791 |
This topic introduces Microsoft SQL Server Integration Services (SSIS) which is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and includes:
- graphical tools and wizards for building and debugging packages
- tasks for performing workflow functions such as FTP operations, executing SQL statements, and sending e-mail messages
- a variety of data sources and destinations for extracting and loading data
- transformations for cleaning, aggregating, merging, and copying data
- a management service, the Integration Services service for administering package execution and storage
- application programming interfaces (APIs) for programming the Integration Services object model
SSIS is included in SQL Server Data Tools (SSDT) and is a Windows application, so use SSIS when you have a Windows machine that can connect to a remote SQL Server instance on Linux. SSIS supports Microsoft SQL Server running on-premises or in the cloud, on Linux, Windows or Docker and also Azure SQL Database and Azure SQL Data Warehouse.
To get started, download the latest version of SQL Server Data Tools (SSDT) and follow the tutorial SSIS How to Create an ETL Package.