Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuNí thacaítear leis an mbrabhsálaí seo a thuilleadh.
Uasghrádú go Microsoft Edge chun leas a bhaint as na gnéithe is déanaí, nuashonruithe slándála, agus tacaíocht theicniúil.
Applies to:
SQL Server - Linux
This article describes how to run SQL Server Integration Services (SSIS) packages on Linux. SSIS solves complex data integration problems by extracting data from multiple sources and formats, transforming and cleansing the data, and loading the data into 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 Synapse Analytics, ODBC data sources, flat files, and other data sources including ADO.NET sources, XML files, and OData services.
For more info about the capabilities of SSIS, see SQL Server Integration Services.
To run SSIS packages on a Linux computer, first you have to install SQL Server Integration Services. SSIS isn't included in the installation of SQL Server for Linux computers. For installation instructions, see Install SQL Server Integration Services (SSIS) on Linux.
You also have to have a Windows computer to create and maintain packages. The SSIS design and management tools are Windows applications that aren't currently available for Linux computers.
To run an SSIS package on a Linux computer, do the following things:
Copy the SSIS package to the Linux computer.
Run the following command:
dtexec /F \<package name \> /DE <protection password>
There are three ways to run an SSIS package that's encrypted with a password:
Set the value of the environment variable SSIS_PACKAGE_DECRYPT
, as shown in the following example:
SSIS_PACKAGE_DECRYPT=test /opt/ssis/bin/dtexec /f package.dtsx
Specify the /de[crypt]
option to enter the password interactively, as shown in the following example:
/opt/ssis/bin/dtexec /f package.dtsx /de
Enter decryption password:
Specify the /de
option to provide the password on the command line, as shown in the following example. This method isn't recommended because it stores the decryption password with the command in the command history.
opt/ssis/bin/dtexec /f package.dtsx /de test
Warning: Using /De[crypt] <password> may store decryption password in command history.
You can use /De[crypt] instead to enter interactive mode,
or use environment variable SSIS_PACKAGE_DECRYPT to set decryption password.
Connect to ODBC data sources. With SSIS on Linux CTP 2.1 Refresh and later, SSIS packages can use ODBC connections on Linux. This functionality has been tested with the SQL Server and the MySQL ODBC drivers, but is also expected to work with any Unicode ODBC driver that observes the ODBC specification. At design time, you can provide either a DSN or a connection string to connect to the ODBC data; you can also use Windows authentication. For more info, see the blog post announcing ODBC support on Linux.
Paths. Provide Windows-style paths in your SSIS packages. SSIS on Linux doesn't support Linux-style paths, but maps Windows-style paths to Linux-style paths at run time. Then, for example, SSIS on Linux maps the Windows-style path C:\test
to the Linux-style path /test
.
You can only store packages in the file system on Linux in this release. The SSIS Catalog database and the legacy SSIS service aren't available on Linux for package deployment and storage.
You can use Linux system scheduling tools such as cron
to schedule packages. You can't use SQL Agent on Linux to schedule package execution in this release. For more info, see Schedule SQL Server Integration Services package execution on Linux with cron.
For detailed info about the limitations and known issues of SSIS on Linux, see Limitations and known issues for SSIS on Linux.
For more info about SSIS on Linux, see the following blog posts:
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:
To get started with SSIS, download the latest version of SSIS How to Create an ETL Package.
To learn more about SSIS, see the following articles:
Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniuOiliúint
Modúl
Execute existing SSIS packages in Azure Data Factory - Training
Execute existing SSIS packages in Azure Data Factory or Azure Synapse Pipeline
Deimhniú
Microsoft Certified: Azure Data Engineer Associate - Certifications
Demonstrate understanding of common data engineering tasks to implement and manage data engineering workloads on Microsoft Azure, using a number of Azure services.
Doiciméadúchán
Configure SSIS on Linux with ssis-conf - SQL Server
This article describes how to configure SQL Server Integration Services (SSIS) on Linux with the ssis-conf utility.
Limitations and known issues for SSIS on Linux - SQL Server
This article describes limitations and known issues for SQL Server Integration Services (SSIS) on Linux computers.
Schedule SSIS Packages on Linux with Cron - SQL Server
This article describes how to schedule SQL Server Integration Services (SSIS) packages on Linux with the cron service.
Install SQL Server Integration Services on Linux - SQL Server
This article describes how to install SQL Server Integration Services (SSIS) on Linux. You can install SSIS on Ubuntu and Red Hat Enterprise Linux.