You must specify a connection for the newly created

Microsoft Azure Data Lake Storage Gen2

target in the

Connection

field to run a mapping.

When you select a flat resource format that contains different data types and select the

Create Target

option to create a

Microsoft Azure Data Lake Storage Gen2

target, the Data Integration Service creates string ports for all the data types with a precision of 256 characters.

When you select a flat resource format to create a

Microsoft Azure Data Lake Storage Gen2

target, the Data Integration Service maps all the data types in the source file to the String data type in the target file. You must manually map the data types in the source and target files.

For a newly created

Microsoft Azure Data Lake Storage Gen2

target, the Data Integration Service considers the value of the root container that you specify in the

Directory

connection property and file name from the

Native Name

property in the

Microsoft Azure Data Lake Storage Gen2

data object details.

When you use a flat resource format to create a target, the Data Integration Service considers the following values for the formatting options:

Formatting Options	Values
Delimiters	Comma (,)
Text Qualifier	No quotes
Import Column Names From First Line	Generates header
Row Delimiter	Backslash with a character n (\n)
Escape Character	Empty