Page History
...
| Note |
|---|
If the source database does not support Windows authentication, a username and password must be specified in the User ID and User Password fields below. |
| Excerpt Include | ||||||
|---|---|---|---|---|---|---|
|
Other
Options | Description | ||
|---|---|---|---|
Default Schema for Browsing | Optional comma-delimited list of schemas for the browser pane filter. Enter the schema(s) you want the connection to browse by default on the right browser pane. | ||
New Table Default Load Type | The default Load Type for new Load tables is created using this connection. Select the desired default load type from Native ODBC, Integration Services load, or ODBC load.
| ||
New Table Default Load Script Connection | The default Script Connection to use when a Script-based load type is defined for a Load table object that is sourced from this connection. | ||
New Table Default Load Script Template | The default Script Template to use when a Script-based load type is defined for a Load table object that is sourced from this connection. | ||
SSIS Connection String (OLEDB) | |||
Data Type Mapping Set | Mapping Set to use when converting from a source database data type to a destination database data type. Setting this field to (Default) makes RED automatically select the relevant mapping set, otherwise, you can choose one of the standard mapping sets from the drop-down list or create a new set. | ||
Default Transform Function Set | Function set that is selected by default in the Transformation dialogs. |
...