Target Property | Description |
|---|---|
Connection | Name of the target connection. |
Target Object | Name of the target object. Select the primary target object. |
Create Target | Creates a target. Enter a name for the target object and select the source fields that you want to use. By default, all source fields are used. |
Display technical names instead of labels | Displays technical names instead of business names. |
Display source fields in alphabetical order | Displays source fields in alphabetical order instead of the order returned by the source system. |
Advanced Target Property | Description |
|---|---|
Azure Blob Container Name | Name of the container in Microsoft Azure Storage to use for staging before writing to Microsoft Azure SQL Data Warehouse. |
Field Delimiter | Character used to separate fields in the file. Default is 0x1e. You can select the following field delimiters from the list: ~ ` | . TAB 0x1e |
Update Column | The key columns to upsert or update data to or delete data from Microsoft Azure SQL Data Warehouse. |
Number of Concurrent Connections to Blob Store | Number of threads to use to move data to the staging area in Microsoft Azure Blob Storage. Default is 4. |
Truncate Table | Truncates the target data before inserting the data to the target. This option is applicable for insert operation. |
Quote Character | Specifies the quote character to skip when you write data to Microsoft Azure SQL Data Warehouse. When you write data to Microsoft Azure SQL Data Warehouse and the source table contains the specified quote character, the task fails. Change the quote character value to a value that does not exist in the source table. |
Pre-SQL | Pre-SQL command that must be run before reading data from the source. |
Post- SQL | Post-SQL command that must be run after writing data to the target. |
Success File Directory | NA |
Error File Directory | NA |