Microsoft Azure Data Lake Storage Gen2 Connector

Back Next

Specifying a target

You can use an existing target or create a target to hold the results of a mapping. If you choose to create the target, the agent creates the target when you run the task.

To specify the target properties, follow these steps:

Select the Target transformation in the mapping.

On the

Incoming Fields

tab, configure field rules to specify the fields to include in the target.

To specify the target, click the

Target

tab.

Select the target connection.

For the target type, choose

Single Object

Parameter

Specify the target object or parameter.

To create a target file at run time, enter the name for the target file including the extension, for example,

Accounts.csv

When you read from a flat file, ensure that the file contains some data and not the header alone. If the file has only a header, the header is not written to the target.

If you want the file name to include a time stamp, click

Handle Special Characters

and add special characters to the file name. For example, add the special characters shown here to include all the time stamp information:

Accounts_%d%m%y%T.csv

If you want the folder name to include a time stamp, click

Handle Special Characters

and add the folder name separated with a back slash (\) followed by the file name. For example,

%Y%m%d\Target_filename_%m.csv

The Handle Special Characters option is not applicable to mappings in advanced mode.

Click

Formatting Options

if you want to configure the formatting options for the file, and click