Select a connection. The list of available connections depends on the task operation defined for the task.

To create a connection, click

New

. To edit a connection, click

View

, and in the

View Connection

dialog box, click

Edit

.

If the connection includes less than 200 objects, select a target object or click

Select

.

If the connection includes more than 200 objects, click

Select

.

The

Select Target Object

dialog box displays up to 200 objects. If the object you want to use does not appear, enter a search string to reduce the number of objects that display.

Select a target object and click

OK

.

Not available for all connection types.

For Flat File and FTP/SFTP connections only. Select a delimiter and text qualifier. Optionally, select an escape character.

If you choose Other for the delimiter, the delimiter cannot be an alphanumeric character or a double quotation mark.

If you choose a delimiter for an FTP/SFTP flat file,

Data Integration

applies the delimiter to the local file, not the remote file, when previewing and reading data. If the remote and local files are not synchronized, you might see unexpected results.

Flat File and relational database connections only. Creates a target file.

You can create a target file when the source connection is Salesforce, database, or ODBC, and the source object is Single or Custom.

Enter a file name and select the source fields that you want to use. By default, all source fields are used.

Database targets with the Insert task operation only. Truncates a database target table before inserting new rows.

True. Truncates the target table before inserting all rows.
False. Inserts new rows without truncating the target table.

Default is False.

Select this option to write data in bulk mode. The default value is false.