Skip to content

Commit bbe444b

Browse files
douglaslMSdouglaslMS
committed
Added CU3 updates to 2 SSIS-on-Linux articles.
1 parent 7c3dc27 commit bbe444b

2 files changed

Lines changed: 53 additions & 2 deletions

File tree

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

Lines changed: 29 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@ author: leolimsft
55
ms.author: lle
66
ms.reviewer: douglasl
77
manager: craigg
8-
ms.date: 10/02/2017
8+
ms.date: 01/09/2018
99
ms.topic: article
1010
ms.prod: "sql-non-specified"
1111
ms.prod_service: "database-engine"
@@ -42,6 +42,34 @@ To run an SSIS package on a Linux computer, do the following things:
4242
$ dtexec /F \<package name \> /DE <protection password>
4343
```
4444
45+
## Run an encrypted (password-protected) package
46+
There are three ways to run an SSIS package that's encrypted with a password:
47+
48+
1. Set the value of the environment variable `SSIS_PACKAGE_DECRYPT`, as shown in the following example:
49+
50+
```
51+
SSIS_PACKAGE_DECRYPT=test /opt/ssis/bin/dtexec /f package.dtsx
52+
```
53+
54+
2. Specify the `/de[crypt]` option to enter the password interactively, as shown in the following example:
55+
56+
```
57+
/opt/ssis/bin/dtexec /f package.dtsx /de
58+
59+
Enter decryption password:
60+
```
61+
62+
3. Specify the `/de` option to provide the password on the command line, as shown in the following example. This method is not recommended because it stores the decryption password with the command in the command history.
63+
64+
```
65+
opt/ssis/bin/dtexec /f package.dtsx /de test
66+
67+
Warning: Using /De[crypt] <password> may store decryption password in command history.
68+
69+
You can use /De[crypt] instead to enter interactive mode,
70+
or use environment variable SSIS_PACKAGE_DECRYPT to set decryption password.
71+
```
72+
4573
## Design packages
4674
4775
**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](https://blogs.msdn.microsoft.com/ssis/2017/06/16/odbc-is-supported-in-ssis-on-linux-ssis-helsinki-ctp2-1-refresh/).

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

Lines changed: 24 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@ author: leolimsft
55
ms.author: lle
66
ms.reviewer: douglasl
77
manager: craigg
8-
ms.date: 10/02/2017
8+
ms.date: 01/08/2018
99
ms.topic: article
1010
ms.prod: "sql-non-specified"
1111
ms.prod_service: "database-engine"
@@ -115,6 +115,29 @@ To remove `mssql-server-is`, you can run following command:
115115
sudo yum remove mssql-server-is
116116
```
117117

118+
## Unattended installation
119+
To run an unattended installation when you run `ssis-conf setup`, do the following things:
120+
1. Specify the `-n` (no prompt) option.
121+
2. Provide required values by setting environment variables.
122+
123+
The following example does the following things:
124+
1. Installs SSIS.
125+
2. Specifies the Developer edition by providing a value for the `SSIS_PID` environment variable.
126+
3. Accepts the EULA by providing a value for the `ACCEPT_EULA` environment variable.
127+
4. Runs an unattended installation by specifying the `-n` (no prompt) option.
128+
129+
```
130+
sudo SSIS_PID= Developer ACCEPT_EULA=Y /opt/ssis/bin/ssis-conf -n setup
131+
```
132+
133+
### Environment variables for unattended installation
134+
135+
| Environment variable | Description |
136+
|---|---|
137+
| **ACCEPT_EULA** | Accepts the SQL Server license agreement when set to any value (for example, `Y`).|
138+
| **SSIS_PID** | Sets the SQL Server edition or product key. Here are the possible values:<br/>Evaluation<br/>Developer<br/>Express <br/>Web <br/>Standard<br/>Enterprise <br/>A product key<br/><br/>If you specify a product key, the product key must be in the form `#####-#####-#####-#####-#####`, where `#` is a letter or a number. |
139+
| | |
140+
118141
## Next steps
119142

120143
To run SSIS packages on Linux, see [Extract, transform, and load data for SQL Server on Linux with SSIS](sql-server-linux-migrate-ssis.md).

0 commit comments

Comments
 (0)