Skip to content

sql-server-linux-migrate-ssis.md

Latest commit

 

History

History
73 lines (53 loc) · 3.64 KB

sql-server-linux-migrate-ssis.md

File metadata and controls

73 lines (53 loc) · 3.64 KB
title Extract, transform, and load data on Linux with SSIS | Microsoft Docs
description
author sanagama
ms.author sanagama
manager jhubbard
ms.date 06/29/2017
ms.topic article
ms.prod sql-linux
ms.technology database-engine
ms.assetid 9dab69c7-73af-4340-aef0-de057356b791

Extract, transform, and load data on Linux with SSIS

This topic describes how to run SQL Server Integration Services (SSIS) packages on Linux. SSIS solves complex data integration problems by loading data from multiple sources and formats, transforming and cleansing the data, and updating multiple destinations.

SSIS packages running on Linux can connect to Microsoft SQL Server running on Windows on-premises or in the cloud, on Linux, or in Docker. They can also connect to Azure SQL Database, Azure SQL Data Warehouse, and ODBC data sources.

You can use SSIS to run packages on Linux when you also have a Windows computer to create and maintain packages. The SSIS design and management tools are Windows applications.

Prerequisites

To run SSIS packages on a Linux computer, first you have to install SQL Server Integration Services. For installation instructions, see Install SQL Server Integration Services.

Run an SSIS package

To run an SSIS package on a Linux computer, do the following things:

  1. Copy the SSIS package to the Linux computer.
  2. Run the following command: 
    $ dtexec /F \<package name \> /DE <protection password>

More about SSIS

Microsoft SQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and loading (ETL) packages for data warehousing. For more info about SSIS, see SQL Server Integration Services.

SSIS includes the following features:

  • graphical tools and wizards for building and debugging packages on Windows
  • a variety of 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
  • a variety of transformations for cleaning, aggregating, merging, and copying data
  • application programming interfaces (APIs) for extending SSIS with your own custom scripts and components

To get started with SSIS, download the latest version of SQL Server Data Tools (SSDT). Then follow the tutorial SSIS How to Create an ETL Package.

More about SSIS on Linux

For limitations and known issues with SSIS on Linux, see the Release Notes.

For more info about SSIS on Linux, see the following blog posts:

See also