Microsoft Azure SQL Data Warehouse V2 Source Properties

Source Property	Description
Connection	Name of the source connection.
Source Type	Type of the source object. Select Single.
Source Object	Name of the source object.
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 Source Property	Description
Azure Blob Container Name	Name of the container in Microsoft Azure Storage to use for staging before extracting data from 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
Number of Concurrent Connections to Blob Store	Number of concurrent connections to extract data to the staging area in Microsoft Azure Blob Storage. Default is 4.
SQL Override	When you read data from a Microsoft Azure SQL Data Warehouse object, you can configure SQL overrides and define constraints.
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.
On Pre-Post SQL Error	Determines the behavior when a task that includes pre-SQL or post-SQL commands encounters errors. You can select any of the following options: - Continue. The task continues regardless of errors. - Stop. The task stops when errors occur while executing pre-SQL or post-SQL commands.
Quote Character	The Secure Agent Skips the specified character when you read data from Microsoft Azure SQL Data Warehouse.