Skip to content

Commit 7012dc4

Browse files
douglaslMSdouglaslMS
committed
Cut known issues into new article. Made metadata consistent across SSIS pages.
1 parent 9042da1 commit 7012dc4

6 files changed

Lines changed: 135 additions & 118 deletions

‎docs/linux/TOC.md‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -57,6 +57,7 @@
5757
### [Bulk copy with bcp](sql-server-linux-migrate-bcp.md)
5858

5959
## [Extract, transform, load](sql-server-linux-migrate-ssis.md)
60+
### [Limitations and known issues](sql-server-linux-ssis-known-issues.md)
6061
### [Configure SSIS](sql-server-linux-configure-ssis.md)
6162
### [Schedule SSIS packages](sql-server-linux-schedule-ssis-packages.md)
6263

‎docs/linux/sql-server-linux-configure-ssis.md‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,14 +1,14 @@
11
---
22
title: Configure SSIS on Linux with ssis-conf | Microsoft Docs
3-
description: This article shows how to configure SQL Server Integration Services on Linux with the ssis-conf utility.
4-
author: douglaslMS
5-
ms.author: douglasl
3+
description: This article describes how to configure SQL Server Integration Services (SSIS) on Linux with the ssis-conf utility.
4+
author: leolimsft
5+
ms.author: lle
6+
ms.reviewer: douglasl
67
manager: craigg
7-
ms.date: 09/26/2017
8+
ms.date: 10/02/2017
89
ms.topic: article
910
ms.prod: sql-linux
1011
ms.technology: database-engine
11-
ms.assetid:
1212
---
1313
# Configure SQL Server Integration Services on Linux with ssis-conf
1414

‎docs/linux/sql-server-linux-migrate-ssis.md‎

Lines changed: 2 additions & 106 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
---
22
title: Extract, transform, and load data on Linux with SSIS | Microsoft Docs
3-
description:
3+
description: This article describes SQL Server Integration Services (SSIS) for Linux computers
44
author: leolimsft
55
ms.author: lle
66
ms.reviewer: douglasl
@@ -9,7 +9,6 @@ ms.date: 10/02/2017
99
ms.topic: article
1010
ms.prod: sql-linux
1111
ms.technology: database-engine
12-
ms.assetid: 9dab69c7-73af-4340-aef0-de057356b791
1312
---
1413
# Extract, transform, and load data on Linux with SSIS
1514

@@ -51,110 +50,7 @@ To run an SSIS package on a Linux computer, do the following things:
5150
5251
## Limitations and known issues
5352
54-
### General limitations and known issues
55-
56-
The following features are not supported in this release of SSIS on Linux:
57-
- SSIS Catalog database
58-
- Scheduled package execution by SQL Agent
59-
- Windows Authentication
60-
- Third-party components
61-
- Change Data Capture (CDC)
62-
- SSIS Scale Out
63-
- Azure Feature Pack for SSIS
64-
- Hadoop and HDFS support
65-
- Microsoft Connector for SAP BW
66-
67-
For other limitations and known issues with SSIS on Linux, see the [Release Notes](sql-server-linux-release-notes.md#ssis).
68-
69-
### <a name="components"></a> Supported and unsupported components
70-
71-
The following built-in Integration Services components are supported on Linux. Some of them have limitations on the Linux platform, as described in the following tables.
72-
73-
Built-in components that are not listed here are not supported on Linux.
74-
75-
#### Supported control flow tasks
76-
- Bulk Insert Task
77-
- Data Flow Task
78-
- Data Profiling Task
79-
- Execute SQL Task
80-
- Execute T-SQL Statement Task
81-
- Expression Task
82-
- FTP Task
83-
- Web Service Task
84-
- XML Task
85-
86-
#### Control flow tasks supported with limitations
87-
88-
| Task | Limitations |
89-
|------------|---|
90-
| Execute Process task | Only supports in-process mode. |
91-
| File System task | The *Move directory* and *Set file attributes* actions are not supported. |
92-
| Script task | Only supports standard .NET Framework APIs. |
93-
| Send Mail task | Only supports anonymous user mode. |
94-
| Transfer Database task | UNC paths are not supported. |
95-
| | |
96-
97-
#### Supported control flow containers
98-
- Sequence Container
99-
- For Loop Container
100-
- Foreach Loop Container
101-
102-
#### Supported data flow sources and destinations
103-
- Raw File source and destination
104-
- XML Source
105-
106-
#### Data flow sources and destinations supported with limitations
107-
108-
| Component | Limitations |
109-
|------------|---|
110-
| ADO.NET source and destination | Only support the SQLClient data provider. |
111-
| Flat File source and destination | Only support Windows-style file paths, to which the default path mapping rule is applied. For example `D:\home\ssis\travel.csv` becomes `/home/ssis/travel.csv`. |
112-
| OData source | Only supports Basic authentication. |
113-
| ODBC source and destination | Supports 64-bit Unicode ODBC drivers on Linux. Depends on the UnixODBC driver manager on Linux. |
114-
| OLE DB source and destination | Only support SQL Server Native Client 11.0 and Microsoft OLE DB Provider for SQL Server. |
115-
| | |
116-
117-
#### Supported data flow transformations
118-
- Aggregate
119-
- Audit
120-
- Balanced Data Distributor
121-
- Character Map
122-
- Conditional Split
123-
- Copy Column
124-
- Data Conversion
125-
- Derived Column
126-
- Export Column
127-
- Fuzzy Grouping
128-
- Fuzzy Lookup
129-
- Import Column
130-
- Lookup
131-
- Merge
132-
- Merge Join
133-
- Multicast
134-
- Pivot
135-
- Row Count
136-
- Slowly Changing Dimension
137-
- Sort
138-
- Term Lookup
139-
- Union All
140-
- Unpivot
141-
142-
#### Data flow transformations supported with limitations
143-
144-
| Component | Limitations |
145-
|------------|---|
146-
| OLE DB Command transformation | Same limitations as the OLE DB source and destination. |
147-
| Script component | Only supports standard .NET Framework APIs. |
148-
| | |
149-
150-
### Supported and unsupported log providers
151-
All the built-in SSIS log providers are supported on Linux except the Windows Event Log provider.
152-
153-
The SQL Server log provider supports only SQL Authentication; it does not support Windows Authentication.
154-
155-
The SSIS log providers for Text files, for XML files, and for SQL Server Profiler write their output to a file that you specify. The following considerations apply to the file path:
156-
- If you don't provide a path, the log provider writes to the current directory of the host. If the current user doesn't have permission to write to the current directory of the host, the log provider raises an error.
157-
- You can't use an environment variable in a file path. If you specify an environment variable, the literal text that you specify appears in the file path. For example, if you specify `%TMP%/log.txt`, the log provider appends the literal text `/%TMP%/log.txt` to the current host directory.
53+
For detailed info about the limitations and known issues of SSIS on Linux, see [Limitations and known issues for SSIS on Linux](sql-server-linux-ssis-known-issues.md).
15854
15955
## More info about SSIS on Linux
16056

‎docs/linux/sql-server-linux-schedule-ssis-packages.md‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,14 +1,14 @@
11
---
22
title: Schedule SSIS packages on Linux with cron | Microsoft Docs
3-
description: This article shows how to schedule SQL Server Integration Services packages on Linux with the cron service.
4-
author: douglaslMS
5-
ms.author: douglasl
3+
description: This article describes how to schedule SQL Server Integration Services (SSIS) packages on Linux with the cron service.
4+
author: leolimsft
5+
ms.author: lle
6+
ms.reviewer: douglasl
67
manager: craigg
7-
ms.date: 09/26/2017
8+
ms.date: 10/02/2017
89
ms.topic: article
910
ms.prod: sql-linux
1011
ms.technology: database-engine
11-
ms.assetid:
1212
---
1313
# Schedule SQL Server Integration Services package execution on Linux with cron
1414

‎docs/linux/sql-server-linux-setup-ssis.md‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
---
22
title: Install SQL Server Integration Services on Linux | Microsoft Docs
3-
description: This topic describes how to install SQL Server Integration Services on Linux.
3+
description: This topic describes how to install SQL Server Integration Services (SSIS) on Linux.
44
author: leolimsft
55
ms.author: lle
66
ms.reviewer: douglasl
@@ -9,7 +9,6 @@ ms.date: 10/02/2017
99
ms.topic: article
1010
ms.prod: sql-linux
1111
ms.technology: database-engine
12-
ms.assetid:
1312
---
1413
# Install SQL Server Integration Services (SSIS) on Linux
1514

‎docs/linux/sql-server-linux-ssis-known-issues.md‎

Lines changed: 121 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,121 @@
1+
---
2+
title: Limitations and known issues for SSIS on Linux | Microsoft Docs
3+
description: This article describes limitations and known issues for SQL Server Integration Services (SSIS) on Linux computers
4+
author: leolimsft
5+
ms.author: lle
6+
ms.reviewer: douglasl
7+
manager: craigg
8+
ms.date: 10/02/2017
9+
ms.topic: article
10+
ms.prod: sql-linux
11+
ms.technology: database-engine
12+
---
13+
# Limitations and known issues for SSIS on Linux
14+
15+
This topic describes current limitations and known issues for SQL Server Integration Services (SSIS) on Linux.
16+
17+
## General limitations and known issues
18+
19+
The following features are not supported in this release of SSIS on Linux:
20+
- SSIS Catalog database
21+
- Scheduled package execution by SQL Agent
22+
- Windows Authentication
23+
- Third-party components
24+
- Change Data Capture (CDC)
25+
- SSIS Scale Out
26+
- Azure Feature Pack for SSIS
27+
- Hadoop and HDFS support
28+
- Microsoft Connector for SAP BW
29+
30+
For other limitations and known issues with SSIS on Linux, see the [Release Notes](sql-server-linux-release-notes.md#ssis).
31+
32+
## <a name="components"></a> Supported and unsupported components
33+
34+
The following built-in Integration Services components are supported on Linux. Some of them have limitations on the Linux platform, as described in the following tables.
35+
36+
Built-in components that are not listed here are not supported on Linux.
37+
38+
### Supported control flow tasks
39+
- Bulk Insert Task
40+
- Data Flow Task
41+
- Data Profiling Task
42+
- Execute SQL Task
43+
- Execute T-SQL Statement Task
44+
- Expression Task
45+
- FTP Task
46+
- Web Service Task
47+
- XML Task
48+
49+
### Control flow tasks supported with limitations
50+
51+
| Task | Limitations |
52+
|------------|---|
53+
| Execute Process task | Only supports in-process mode. |
54+
| File System task | The *Move directory* and *Set file attributes* actions are not supported. |
55+
| Script task | Only supports standard .NET Framework APIs. |
56+
| Send Mail task | Only supports anonymous user mode. |
57+
| Transfer Database task | UNC paths are not supported. |
58+
| | |
59+
60+
### Supported control flow containers
61+
- Sequence Container
62+
- For Loop Container
63+
- Foreach Loop Container
64+
65+
### Supported data flow sources and destinations
66+
- Raw File source and destination
67+
- XML Source
68+
69+
### Data flow sources and destinations supported with limitations
70+
71+
| Component | Limitations |
72+
|------------|---|
73+
| ADO.NET source and destination | Only support the SQLClient data provider. |
74+
| Flat File source and destination | Only support Windows-style file paths, to which the default path mapping rule is applied. For example `D:\home\ssis\travel.csv` becomes `/home/ssis/travel.csv`. |
75+
| OData source | Only supports Basic authentication. |
76+
| ODBC source and destination | Supports 64-bit Unicode ODBC drivers on Linux. Depends on the UnixODBC driver manager on Linux. |
77+
| OLE DB source and destination | Only support SQL Server Native Client 11.0 and Microsoft OLE DB Provider for SQL Server. |
78+
| | |
79+
80+
### Supported data flow transformations
81+
- Aggregate
82+
- Audit
83+
- Balanced Data Distributor
84+
- Character Map
85+
- Conditional Split
86+
- Copy Column
87+
- Data Conversion
88+
- Derived Column
89+
- Export Column
90+
- Fuzzy Grouping
91+
- Fuzzy Lookup
92+
- Import Column
93+
- Lookup
94+
- Merge
95+
- Merge Join
96+
- Multicast
97+
- Pivot
98+
- Row Count
99+
- Slowly Changing Dimension
100+
- Sort
101+
- Term Lookup
102+
- Union All
103+
- Unpivot
104+
105+
### Data flow transformations supported with limitations
106+
107+
| Component | Limitations |
108+
|------------|---|
109+
| OLE DB Command transformation | Same limitations as the OLE DB source and destination. |
110+
| Script component | Only supports standard .NET Framework APIs. |
111+
| | |
112+
113+
### Supported and unsupported log providers
114+
All the built-in SSIS log providers are supported on Linux except the Windows Event Log provider.
115+
116+
The SQL Server log provider supports only SQL Authentication; it does not support Windows Authentication.
117+
118+
The SSIS log providers for Text files, for XML files, and for SQL Server Profiler write their output to a file that you specify. The following considerations apply to the file path:
119+
- If you don't provide a path, the log provider writes to the current directory of the host. If the current user doesn't have permission to write to the current directory of the host, the log provider raises an error.
120+
- You can't use an environment variable in a file path. If you specify an environment variable, the literal text that you specify appears in the file path. For example, if you specify `%TMP%/log.txt`, the log provider appends the literal text `/%TMP%/log.txt` to the current host directory.
121+

0 commit comments

Comments
 (0)